Hello all, I am trying to change part of a field across several hundred rows, and am having difficulties. Here's the setup: I have rows with field values of "Rodregues0001" through "Rodregues0214". What I wish to do is change the "Rodregues" to "TampaBay" while leaving the number intact. Is there a way to do this in MySQL? Some sort of search and replace command?
Thanks. -bryan ===== --------------------------------------------------------------------------- Schrodinger may have slept here. --------------------------------------------------------------------------- __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- 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