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,
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
Hi everyone,
ok, so I know how to use RLIKE to match regular expressions. However,
let's say I have an isbn number of:
0-06-430022-6
saved in the database but someone wants to search for it by entering:
0064300226
or even
006-430-0226
So the search query needs to have its dashes removed
function
that replaced all '-' with nothing. So it matched 12 from the user
input -1-2-.
If that works for you, let me know.
bob
Luke Majewski wrote:
Hi everyone,
ok, so I know how to use RLIKE to match regular expressions. However,
let's say I have an isbn number of:
0-06-430022-6
saved