View Single Post
Old 20 Jul 2019, 15:39
TJF TJF is offline
Join Date: Dec 2001
We recently switched our forums to SSL. It was a bit of an ordeal because I don't think our host fully knew what they were doing. I think one tech was able do what we wanted by changing all the http links to https, but then another tech did another restore from a backup and wiped out the changes.

I want to change all references of to within on entire vBulletin database.

I know this is the SQL query to change it just in the posts.

UPDATE post SET pagetext = REPLACE(pagetext, '', '');

What query would I run to search and replace the entire database? I will, of course, make a backup before running it and check to see the links have been successfully converted.
Reply With Quote