how to use like operator in join operation

Question

how to use like operator in join operation? because i want to join the two table and search the any word of value in table.
my query is

select a.*,b.* from table1 a,table2 b 
where columnname 'like %abc%'

Possible duplicate of [mysql join query using like?](http://stackoverflow.com/questions/1930809/mysql-join-query-using-like) — sobolevn, Nov 14 '15 at 11:23

score 0 · Accepted Answer · answered Nov 14 '15 at 10:30

0

You should not use like keywords in quotes.

Change:

 columnname 'like %abc%'

To:

columnname like '%abc%'

answered Nov 14 '15 at 10:30

Arvind Jaiswal

score 0 · Answer 2 · answered Nov 14 '15 at 10:30

0

Try this:

select a.*,b.* 
from table1 a,table2 b 
where (a.acolumnname LIKE '%abc%') OR
      (b.bcolumnname LIKE '%abc%')

answered Nov 14 '15 at 10:30

asd-tm

@Radhey Why did you unaccept the answer after 2 weeks? – asd-tm Dec 01 '15 at 13:53

2 Answers2