I have a website that is powered by Joomla. I have just changed companies and I need to write a script that will search through all the tables of a given database and search ALL fields within each table. The script needs to find all occurances of "Old Company" and replace it with "New Company".

Can anyone help me out with this, I can't think of where to start and I need it done by tomorrow at the latest.

Any help would be appreciated.

The MySQL command to search all tables is: MYSQL SHOW FROM `db_name`
So when you have all the tables, I'd say you need to fetch the whole table and per row, check each field for 'Old Company' and if matched, replace and update that row in that table.

This is easy only if you know exactly what table your old data is contained in... As in you could throw a mysql statement at your table like this. Note, this will replace everything in your joomla content table that contains one string with another string.

BACKUP YOUR DB before you do anything like this... I'm sure you know that but some people don't take that into consideration. Also, this is assuming you are using (jos_) as a table prefix for your joomla installation.

PHP Code:

UPDATE jos_content SET introtext = REPLACE(introtext, 'oldcompany', 'newcompany'), fulltext = REPLACE(fulltext, 'oldcompany', 'newcompany'); 


I think that should cover everything in your content, if not then look for component tables in your database and use the same mysql replace syntax to switch out your words.

Also, there is a sitename variable in your configuration file set to display the name of your website. I assume this is not pertinent, but just had to check.

Thank you... I didn't realize that it would be so difficult. I need to change many instances of the words thorughout the whole site.

Forget about it. As I set, I thought I would be ablet do something like UPDATE * FROM * REPLACE(*, 'old company', 'new company), or something like that.

I just stayed up really late and did it manually.