Matt Davis (matt@stripped) 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 replace in My SQL?
(1) Normalize your database, and you won't have this problem again.
(2) UPDATE table SET field='new-value' WHERE field='old-value';
--
Ed Carp, N7EKG erc@stripped 940/367-2744 cell phone
http://www.pobox.com/~erc ercpager@stripped - text pager
I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.
