I am trying to do an import from XF to vb4.2 and after using Impex with the XF addon from over at vb.org all is ok however there is some cleaning up to do. One specific need is to address videos that are inlione in a post. I need to do a string search and replace in the db and not sure what the sql woul be.
The string in posts that needs to be changed is:
It needs to be changed to:
The problem is that the string rGALfBuKbWc is a variable that is different in each post (it is the YouTube videoID)
Any ideas what the SQL would be that I could run in the database that would replace the string using the variable and thus display the video in the post?
The string in posts that needs to be changed is:
Code:
media=youtube][COLOR=#ff0000]rGALfBuKbWc[/COLOR][/media
Code:
video=youtube;[COLOR=#ff0000]rGALfBuKbWc[/COLOR]]http://www.youtube.com/watch?v=[COLOR=#ff0000]rGALfBuKbWc[/COLOR][/video
Any ideas what the SQL would be that I could run in the database that would replace the string using the variable and thus display the video in the post?
Comment