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'.
Is there a simple way I can prevent errors from a search string that
contains ^*$ or other sensitive expression
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'.
Is there a simple way I can prevent errors from a search string
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
AND parents NOT RLIKE '^\* New Category \*(|$)' ORDER