I have managed to change some old bbcode not used anymore on elkarte. I used
UPDATE [icode]elkarte_messages[/icode] SET [icode]body[/icode] = REPLACE([icode]body[/icode],'text1','text2')
I had an old version of tapatalk that was not supporting emoticons and now I have some bbcode like [emoji2] or [emoji123]
How could I remove all these old bbcodes? Thank you