Global search and replace utility

2008-10-09 Thread mike cantor 
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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Global search and replace utility

2008-10-09 Thread Rob Wultsch 
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]