使用LIKE在mysql中搜索确切的单词

Question

please help., Lets say I want to search the word "INK"

when I use LIKE Im getting every word the has the "INK" letters on it including "wrINKled".,

if I use REGEXP I will only get results that has the word 'INK" as the first word.,

I need to be able to search the exact word for example "BLAAAH INK Blah" this product will show because it has the word ink., so as "INK blah blah"..

I cant use FULLTEXT is there a way to do this using LIKE..?

Thank you in advance.. :)

Answer 1

The query will be

SELECT * FROM table_name
WHERE column_name LIKE 'INK %' 
    OR column_name LIKE '% INK' 
    OR column_name LIKE '% INK %'