Re: Escaping * character in a RLIKE? How? Help?

2001-07-14 Thread Paul DuBois
At 6:15 PM -0500 7/14/01, Paul DuBois wrote: >At 3:15 PM -0700 7/14/01, xris wrote: >>I have a very simple query that used to work and then recently stopped. It >>goes something like: >> >>SELECT name FROM Items WHERE category RLIKE '^\* new cat \*'; >> >>Now, I'm pretty familiar with how regex w

Re: Escaping * character in a RLIKE? How? Help?

2001-07-14 Thread Paul DuBois
At 3:15 PM -0700 7/14/01, xris wrote: >I have a very simple query that used to work and then recently stopped. It >goes something like: > >SELECT name FROM Items WHERE category RLIKE '^\* new cat \*'; > >Now, I'm pretty familiar with how regex works, and I was pretty sure that >when I put a \ in

Escaping * character in a RLIKE? How? Help?

2001-07-14 Thread xris
I have a very simple query that used to work and then recently stopped. It goes something like: SELECT name FROM Items WHERE category RLIKE '^\* new cat \*'; Now, I'm pretty familiar with how regex works, and I was pretty sure that when I put a \ in front of the * it would interpret it as a * i