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 fiel
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?
Matt Davis ([EMAIL PROTECTED]) writes:
> 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 r
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
--
