XF 1.2 SQL Query to mass update matching post data

[Moddis]

After the migration from VB, there are still some quirks im working out and one of them is a media tag from an old mod.

Is it possible to write a SQL Query that would update the following in all posts?


FROM:

[ame=http://www.youtube.com/watch?v=8t8jo4cMGIU]Funny Video - YouTube[/ame]

TO:

[media=youtube]8t8jo4cMGIU[/media]

or TO: At least to original url:

http://www.youtube.com/watch?v=8t8jo4cMGIU

Would appreciate any guidance that woudl easily help me clean up this data. If this is beyond the scope of simply running an SQl quesry, my second option was just to do a query to delete all instances of "[ame=" and "[/ame]"

Thanks!

 

[Jeremy]

There are several examples of converting the BBCode over to XenForo's syntax:
http://xenforo.com/community/resources/post-content-find-replace.1549/

 

[Moddis]

That will work!