if you don't want to, or haven't set up a fulltext index on your description field, try adding spaces to the beginning and the end of the search term;
WHERE description LIKE '% searchterm %'
the best method is to create a fulltext index on your description field, then search by a pattern match;
"SELECT *, MATCH(description) AGAINST ('searchterm') AS score FROM product where MATCH(description) AGAINST ('searchterm') group by score desc"
|