Mass changing video tag

[dtommy79]

Hi,

Before upgrading to 4.0 I had a custom youtube bbcode installed. Its tag looks like this: [yt]

I have lots of youtube video on my forum with this old tag and obviously they don't work with the new [video] bb code.

It would take a lot of time to change them manually. Is there a way to run an sql command or something and change the old bb code tags to the new?

Thanks

[manofphat]

I'm also interested in a solution for this

[Videx]

Personally, being a total idiot when it comes to Mysql, I would do it the dummy way. It's as easy as a search and replace; no need to deal with SQL queries.
Dummy fix for Illegal mix of collations (http://www.vbulletin.com/forum/showthread.php?302754-Dummy-fix-for-Illegal-mix-of-collations&highlight=dummy)