MySQL – How to search for exact word match using LIKE?
Do you just want to search on word boundaries? If so a crude version might be: SELECT * FROM products WHERE product_name LIKE “% foo %”; Or you could be a bit cleverer and look for word boundaries with the following REGEXP SELECT * FROM products WHERE product_name RLIKE “[[:<:]]foo[[:>:]]”;