Multiple words search in single query

by Jayanthi 2013-04-16 17:16:14

Multiple words search in single query

More than one keywords used in like query

Select * from product where name like '%munch%' or name like '%kitkat%' or name like '%boost%' or name like '%sun slick%'



To replace this REGEXP query

SELECT * FROM product WHERE name REGEXP 'munch|kitkat|boost|sun slick';
669
like
0
dislike
0
mail
flag

You must LOGIN to add comments