XF 2.2 Query to replace Twitter bbcode

[TheGroove]

I'm trying to convert all Twitter bbcode posts into simple links before disabling it.

This is how it parses out by default the code after the full link is added

https://twitter.com/i/web/status/1597713774244306944

[MEDIA=twitter]1597713774244306944[/MEDIA]

This is the query I'm attempting to use

UPDATE xf_post SET message = REPLACE(message, '[MEDIA=twitter]', 'https://twitter.com/i/web/status/[URL]');
                                    
UPDATE xf_post SET message = REPLACE(message, '[/MEDIA]', '[/URL]');

This is what it looks like after I run the query, notice the only part that is launchable is the number, I'm obviously missing something here but it feels close.

 

[TheGroove]

I would be willing to pay for this if someone is inclined to help. The bottom line is I want to disable the Twitter bbcode but when I do it, it removes it from all existing posts.

 

[K a M a L]

Your second query will break you content and corrupt other media embeds ( like youtube emeds )
you can try https://xenforo.com/community/threads/post-content-find-replace.135904/ .. addon discussions contains multiple similar examples