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 error 'parentheses not balanced' from regexp
>
>So, I try to escape that open parenthesis with a "\":
>
> mysql> SELECT * FROM table WHERE column REGEXP "^\(text";
>
>Still, I get the same error, 1139. It seems I can't escape the open
>parenthesis! How can I search for a column that begins with a "("?
>
>Any help on this would be appreciated!
In REGEXP patterns, backslashes should be doubled.
>
>--Kevin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
