Forum Replace BB Codes
 

Hey,

After I imported my phpBB forum software to VBulletin, I need to fix all of my custom BB Codes.

One of my BB codes is for WorldStarHipHop videos.

This is the BB Code I used to use for my phpBB forum:

Code:
[wshh]http://www.worldstarhiphop.com/videos/video.php?v=wshhvpf7qedV84D9BUqV[/wshh]
But here is the code I have to use for my VBulletin forum:

Code:
[wshh]wshhvpf7qedV84D9BUqV[/wshh]
Instead of editing every single one of my forum threads, I am going to use MYSQL to replace the characters. Here are some of the codes I have tried:

Code:
UPDATE post
SET
pagetext = replace( pagetext, substring( pagetext, locate( '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=', pagetext ) , 55 ) , '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=' )
WHERE
LOCATE( '[wshh]', pagetext ) >0;
and:

Code:
UPDATE post
SET
pagetext = replace( pagetext, substring( pagetext, locate( '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=%', pagetext ) , 56 ) , '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=%' )
WHERE
LOCATE( '[wshh]', pagetext ) >0;
But none have worked.

Does anyone know how I can do this?

Hope you understand, thanks :)