Parentheses regexp

2002-03-10 Thread aToM
I have a db with some data that includes parentheses, for example: mysql select Artist, Track from tracks where Artist regexp 'Isley Brothers Band'; +-+---+ | Artist | Track |

Re: Parentheses regexp

2002-03-10 Thread Toomas Vendelin
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