Re: The endless collection of BBC codes
Reply #3 –
For anyone upgrading from SMF, this will fix any existing acronym tags (we had a lot of them):
UPDATE elk_messages
SET body=replace(replace(body,'[/acronym','[/abbr'),'[acronym=','[abbr=')
where body like '%[acronym=%'