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

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

global search and replace

2001-02-20 Thread Matt Davis
I have an MySQL table in which one of the fields is a list of different catergorys. I want to change that catergory name to some thing else however it appears in my table just over 900 times. Is there any way I can do some sort of glabal search and replace in My SQL? Mat