Re: Problem with regexp

2004-02-29 Thread Paul DuBois
At 9:42 -0500 2/28/04, Ed Leafe wrote: Hi, I'm trying to get a particular pattern to match, and a pattern that works in Python and other languages is not working in MySQL. I'm using 4.1.0 on RH Linux. I archive messages from an email list, and we have a standard that posts to the list that a

Re: Problem with regexp

2004-02-28 Thread Ed Leafe
On Feb 28, 2004, at 10:33 AM, Michael Stassen wrote: In the meantime, perhaps the following will help: mysql> select 'This is an [OT] Test' regexp "[ [:punct:]]OT[ [:punct:]]" as mtch; Hey, thanks - that works! ___/ / __/ / / Ed Leafe http://leafe.com/ http://op

Re: Problem with regexp

2004-02-28 Thread Michael Stassen
Ed Leafe wrote: Hi, I'm trying to get a particular pattern to match, and a pattern that works in Python and other languages is not working in MySQL. I'm using 4.1.0 on RH Linux. I archive messages from an email list, and we have a standard that posts to the list that are Off Topic shou