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 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 [EMAIL PROTECTED] 940/367-2744 cell phone
http://www.pobox.com/~erc [EMAIL PROTECTED] - 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.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php