On Thu, Oct 9, 2008 at 4:21 PM, mike cantor <[EMAIL PROTECTED]> wrote: > Does anyone know of a utility that can go through a set of tables (or every > table) in a MySql database and preform a global search and replace (i.e. > replace every instance "string1" in a text field with "string2"). Or is > there a super clever query that accomplishes this? > > I have seen a few Windows-based utilities that proport to do this but I am > looking for something I can run on Linux. > > Thanks for any help you can offer! > -Mike
Use the information schema to make a list of all tables and columns, and then run updates on all of them. OR Dump to a text file and run a find and replace in your editor of choice. -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
