Massive BB Code replacement by MySQL query

[Dr. Katz]

Hello,

Forcing use of the new 'Insert Video' functionality, I replace my old [YT]video_id[/YT] tags in posts executing this query on MySQL:

update post set pagetext = Replace(pagetext,'[yt]','[video]http://www.youtube.es/watch?v=');
update post set pagetext = Replace(pagetext,'[/yt]','[/video]');

But now, it's not appearing the embedded player till I manually edit each post. I noticed that the new code that is generated after editing looks like this:

[video=youtube;video_id]http://www.youtube.com/watch?v=video_id[/video]

Therefore, for embedded player displaying I must expand the [video] tag with the parameters in bold, but I don't know what query I should run in mysql to capture the appropiate video_id from the URL...

I saw something like this, but I think it's not the case...

Thanks for your help!!!