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?
...
> > > 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:
RMATION_SCHEMA databases in MySQL 5.0.
mel list_php wrote:
> Hi,
>
> I was wondering if there is any way to do a global search through all
> the tables in mysql? (not taking into account the performance issue)
>
> If for example I want to search "ABC" in all
Hi,
I was wondering if there is any way to do a global search through all the
tables in mysql? (not taking into account the performance issue)
If for example I want to search "ABC" in all the columns of one table:
select * from table where [whatever the column] like '%ABC%'
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
--
