Small problem which is probably quite easy if you know how but after spending hours search for an answer i am still struggling.

The problem i have is trying to search an sql table for an exact term that is entered into a search box. I have everything working but in using the LIKE command with wildcards if you search for something like 'red' it will also return any words that contain that term so it would return 'colouRED'

The searchy bit is just basically

"products_name like '%$search_keywords[$i]%' ";

If it was sql 2000 i belive i could just use CONTAINS instead of LIKE and it would all be sorted. What would the equivilent of this be on Linux?