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
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
#x27;-1-2-' and I told mysql to
give me all records that equaled the result of the replace 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
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
