Find and replace in MySQL - using PHP
No point in re-inventing the wheel, this is very handy:
http://www.mjdigital.co.uk/blog/search-and-replace-text-in-whole-mysql-database/GPL version of updated tool:
https://launchpad.net/mysql-search-replaceUpdate: below is my copy of the script modified to use LIKE instead of REGEX. This best suited my requirement to find and replace URL's. I also added "`" style quotes for Joomla's funny use of reserved names for fields!