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
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
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%'
or globally
select
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 the columns of one table:
select * from table where
to, 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:48:22 +0200
Hello.
It's
,
melanie
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: global search
Date: Wed, 14 Dec 2005 12:48:22 +0200
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
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