[eJM]

Originally Posted by Dr. Katz

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

I have a question regarding your query that doesn't have anything to do with videos, but does have something to do with the text or a URL in a lot of posts. I found this topic via Google because of my particular issue, so others may come to find a similar solution. I hope you can help.

I understand the query to run in the vBulletin AdminCP is:

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");

My table name is tfppost (I use table prefixes), but I wasn't sure I knew what the tablefield was called. You call it pagetext, but I would like to know if the table prefix applies to this as well. I'm very hesitant to run the query for fear of botching it until I have all the syntax down pat. I do have database backups, but that's a hassle I'd like to avoid by making the query right the first time around. I am trying to change a URL (not the BBCode, just the URL inside the BBCode).

Thank you for any guidance.

Jim