I'm trying to run a simple search on my MYSQL database. I need it to recognize word boundaries. So far, that seems to mean I use RLIKE or REGEXP in a command something like this:

SELECT * from products
where prod_name RLIKE [[:<:]]something[[:>:]]

My host's version of mySQL doesn't seem to like this. Is it my syntax, or the version, and is there some other way I can crack this if RLIKE isn't going to work?

Thanks .....

use quotes

where prod_name regexp '[[:<:]]something[[:>:]]'