Re: REGEXP question, newbie

2002-10-10 Thread Paul DuBois
At 16:04 -0400 10/10/02, Kevin wrote: >Another question...I know. Second one in 24 hours...I hate it too. > >I have a column of data that may begin with an open parenthesis "(". When I >do this: > > mysql> SELECT * FROM table WHERE column REGEXP "^(text"; > >I get this: > > ERROR 1139: Got

REGEXP question, newbie

2002-10-10 Thread Kevin
Another question...I know. Second one in 24 hours...I hate it too. I have a column of data that may begin with an open parenthesis "(". When I do this: mysql> SELECT * FROM table WHERE column REGEXP "^(text"; I get this: ERROR 1139: Got error 'parentheses not balanced' from regexp So,