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
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