• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 SQL Query to mass update matching post data

Moddis

Active member
#1
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:
Code:
[ame=http://www.youtube.com/watch?v=8t8jo4cMGIU]Funny Video - YouTube[/ame]
TO:
Code:
[media=youtube]8t8jo4cMGIU[/media]
or TO: At least to original url:
Code:
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!