I have a table with two columns "storename" and "discription".
id---- Storename ---- Description
1 ---- Myntra ---- 20% of on all product
2 ---- Flipkart ---- 40% of on all product
for search i am using 'like' query like this :
select * from table_name where description like %search_terms%;
When I am trying to search "20% off on all product",Its returning 1 result for Myntra,
BUT when i am searching for "20% of on all product and clothes" then its not returning any result.
Because the description row does not contain the words "and clothes".
I know that we can use 'full text index' but it will contain all the results from all the rows.