Hi All,
I have fields like:
"Washable Velour Doll"
in my database and I want to do a boundary match so that when people enter a search field like "Velour" I return all instances where the whole word exists. In other words, 'lour' would not work. I know that reg expressions have boundary matching, so \bVelour\b should match all whole words "Velour."
So I've tried making this into a query many different ways, and since I am a regexp nub I can't seem to find the right query. The basic query looks something like:
select name from resource where name regexp '[\b](searchText)[\b];
Does anyone know whether this is supported? I've also tried writing my own boundary check with limited success.
Any help would be greatly appreciated,
Luke
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]