1. 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

Discussion in 'XenForo Questions and Support' started by Moddis, Dec 8, 2013.

  1. Moddis

    Moddis Active Member

    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!
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Moddis likes this.
  3. Moddis

    Moddis Active Member

    That will work!
     

Share This Page