var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: RLIKE or REGEXP -- too new for 3.23.56?
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?
where prod_name regexp '[[:<:]]something[[:>:]]'