Switch from dbtech [MENTION] bbcode (vBulletin) to [USER] xF2 - A simple query modify

[Scandal]

I'm working the migration of my sites from vBulletin 3 to XenForo 2.1

I have stuck on this issue. On my vBulletin board we ran dbtech user tagging.
That system has the following own bbcode format:
Code:

[MENTION=123]Scandal[/MENTION]

This is very close to the xF2 one:
Code:

[USER=123]@Scandal[/USER]

... with the difference an "@" symbol.

So I want to update all my forum's posts to be normalized with the xF2 one.

The following queries are working, but I don't know how to apply the "@" inside the username. Any...

Read more
Switch from dbtech [MENTION] bbcode (vBulletin) to [USER] xF2 - A simple query modify

free plugins
minecraft paid for free
mcmarket
mc-market
free minecraft paid plugins
free minecraft plugins
spigotmc
SpigotMC
aac free
ewg free
Minecraft Premium Plugins
ewg free download
litebans free
epicworldgenerator free
free schematics
leaked schematics minecraft
schematics
schematics leaked
schematics free
minecraft schematics free
paid minecraft schematics free
paid minecraft schematics for free
free cracked plugins
free cracked minecraft plugins
plugins
featherboard download
featherboard plugin download
antiaura download
xenforo leaked
xenforo for free
xenforo addons