Hello aToM,
It works if you double escape character, i.e.
select Artist, Track from tracks where Track regexp 'Rumour \\(';
in your case (just tested myself). Looks pretty weird, but seems to
work.
Tom
Sunday, March 10, 2002, 10:48:07 AM, you wrote:
a> I have a db with some data that includes parentheses, for example:
mysql>> select Artist, Track from tracks where Artist regexp 'Isley Brothers Band';
a> +-------------------------+-----------------------------------+
a> | Artist | Track |
a> +-------------------------+-----------------------------------+
a> | The Isley Brothers Band | Tell Me It's Just A Rumour (inst) |
a> +-------------------------+-----------------------------------+
a> 1 row in set (0.07 sec)
a> When I try to actually search on the existance of a parentheses I get an
a> error, thus:
mysql>> select Artist, Track from tracks where Track regexp 'Rumour (';
a> ERROR 1139: Got error 'parentheses not balanced' from regexp
mysql>> select Artist, Track from tracks where Track regexp 'Rumour \(';
a> ERROR 1139: Got error 'parentheses not balanced' from regexp
a> Anyone know how I can 'escape' the parentheses?
a> -aToM
a> ---------------------------------------------------------------------
a> Before posting, please check:
a> http://www.mysql.com/manual.php (the manual)
a> http://lists.mysql.com/ (the list archive)
a> To request this thread, e-mail <[EMAIL PROTECTED]>
a> To unsubscribe, e-mail <[EMAIL PROTECTED]>
a> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Best regards,
Toomas mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
