SQL Query Replace Text Issue
 

I am having an issue on my forum where i had a problem with an outdated youtube embed plugin which has caused an issue when i updated my forum.

I have about 1200+ posts with youtube links looking like this now : http://www.youtube.com/watch?v=http:...?v=A5Yj6ImVc1k

when they should look like this:
http://www.youtube.com/watch?v=A5Yj6ImVc1k

I tried this SQL update code but it hasnt worked for me:

UPDATE post SET pagetext = REPLACE(pagetext, 'http://www.youtube.com/watch?v=http', 'http')

Any help that can be assisted would be GREATLY appreciated !

Edit:
I also tried this with no luck:

UPDATE
post
SET
pagetext = replace(pagetext,'http://www.youtube.com/watch?v=http', 'http')
WHERE
pagetext LIKE '%http://www.youtube.com/watch?v=http%'

Edit2: heres an example of an affected post : http://www.djtechtools.com/forum/sho...2&postcount=10