Correction des guillemets après importation phpBB

Soutien
81

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!

82

Ce sujet a été automatiquement fermé après 2324 jours. Les nouvelles réponses ne sont plus autorisées.