mysql regex error #1139 - Got error 'repetition-operator operand invalid' from regexp

Asked Jul 29 '15 at 04:55

Active Jul 29 '15 at 05:18

Viewed 861 times

I'm using a custom regex replace method found here. I put in my own method

UPDATE `catalog_product_entity_text` 
 SET `attribute_id` = regex_replace('^[^.]*^(.*?)\:', '<b>^[^.]*^(.*?)\:</b>', attribute_id)

But when I run this the database gives me the error;

Got error 'repetition-operator operand invalid' from regexp

It says in the documentation in the link above that the NO_BACKSLASH_ESCAPES mode must be set to ON but I'm not sure if this is the issue or how to do this. I have MySQL 5.5.

edited Jul 29 '15 at 05:18

vhu

12,244
11
38
48

asked Jul 29 '15 at 04:55

davidelias16

may i know what are you trying to achieve? – Avinash Raj Jul 29 '15 at 05:15
this may be helpful for you [click here][1] [1]: http://stackoverflow.com/a/18317617/5010527 – Gulim Shah Jul 29 '15 at 06:23
Try `regex_replace('^([^.]*)(.*?):', '\\1\\2:', attribute_id)`. This should enclose the text matched with `(.*?)` in b tags. – Wiktor Stribiżew Jul 29 '15 at 09:10

mysql regex error #1139 - Got error 'repetition-operator operand invalid' from regexp

0 Answers0