Re: REGEXP and word boundary match

2004-06-27 Thread Luke Majewski
Paul DuBois wrote: Why do you think this? That's not what the regex chapter in the MySQL manual says. \b works in Perl, but MySQL isn't Perl. I looked through the pattern matching section and didn't see what you linked below. The easiest way to find out the correct syntax is to look in the MySQ

Re: REGEXP and word boundary match

2004-06-27 Thread Paul DuBois
At 19:14 -0400 6/27/04, Luke Majewski wrote: 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 kn

REGEXP and word boundary match

2004-06-27 Thread Luke Majewski
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 matchi