Multiple words search in single query
by Jayanthi[ Edit ] 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';
