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
...
> > > Is it possible to use wildchars for the search, something like
select *
> > > from step1_* ?
>
> Thanks,
> melanie
>
> >From: Gleb Paharenko <[EMAIL PROTECTED]>
> >To: mysql@lists.mysql.com
> >Subject: Re: global search
> >Date: We
for
> ex step1_table,step1_table2, step2_table
> Is it possible to use wildchars for the search, something like select *
> from step1_* ?
Thanks,
melanie
From: Gleb Paharenko <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: global search
Date: Wed, 14 Dec 2005 12:
Hello.
> It's probably possible to do a small script describing all the columns
> then building a query to search in, but I was wondering if there was
>an already existing mechanism.
Another approach is not to use external scripts, but rather stored
routines and INFORMATION_SCHEMA database
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
