Arno Nühm
Active member
After Import from VBulletin to Xenforo we have a lot of old [ FONT ] Tags (without spaces) that are not rendered correctly.
I guess it's because of the comma inside, e.g.
There are a lot of different FONT-Codes like that inside the xf_posts and I need to remove them all.
I would love to replace all font tags with at least one comma with the first font name and remove the rest.
should be replaced to
There must be any regular expression in mysql to do this?
Can anyone please help me?
I guess it's because of the comma inside, e.g.
Code:
[font=Verdana, Arial, Helvetica, sans-serif]
There are a lot of different FONT-Codes like that inside the xf_posts and I need to remove them all.
I would love to replace all font tags with at least one comma with the first font name and remove the rest.
Code:
[font=Verdana, Arial, Helvetica, sans-serif]
should be replaced to
Code:
[font=Verdana]
There must be any regular expression in mysql to do this?
Can anyone please help me?