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!
--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
