Re: repetition-operator operand invalid

2005-05-11 Thread Gleb Paharenko
[^a-= > zA-Z0-9]*H[^a-zA-Z0-9]*' > > As I said, it worked fine until I upgraded. Is it to do with the > double parsing MySQL does with REGEXP's? > > In some instances, I get emtpy result set where I used to get a match, > and in other instances, I get a &#

repetition-operator operand invalid

2005-05-10 Thread Scott Klarenbach
[^a-zA-Z0-9]*H[^a-zA-Z0-9]*' As I said, it worked fine until I upgraded. Is it to do with the double parsing MySQL does with REGEXP's? In some instances, I get emtpy result set where I used to get a match, and in other instances, I get a 'repetition-operator operand invalid&#

"repetition-operator operand invalid" error?

2001-07-04 Thread Chris Petersen
I recently started getting this error from a query: > Got error 'repetition-operator operand invalid' from > regexp (SELECT id, IF(parents LIKE '_%',CONCAT(parents,' > name),name) AS name, usergrp FROM Categories WHERE id > 10 AND id >