Fix quotes after phpBB import

Looking for some help with these really annoying glow tags. This is how they show up:

[glow=red,2,300]text[/glow]

I tried:

UPDATE posts set raw = regexp_replace(raw, '\[(glow)=red,\d{0,8},\d{0,3}\]', '', 'g') where raw like '%glow%';`

That returns this error: Invalid command \[(glow)=red,. Try \? for help.

I also tried it by escaping the commas and that just returns nothing.

Thanks in advance!

This topic was automatically closed after 2324 days. New replies are no longer allowed.