Heyho!
Robin Lynn Frank wrote:
I hope this question doesn't sound too dumb, but since I can't afford to screw it up...
I have a table with 98,000 records. I want to globally replace the content of one field where the content is
XXXXXXX diverse_text
with
XXXXXXX non-diverse_new_text
In other words, if the content of the field starts XXXXXXX, I want it replaced with XXXXXXX with only the new text following.
Use update: UPDATE your_tbl SET the_field = 'XXXXXXX non-diverse_new_text' WHERE the_field = 'XXXXXXX%'
http://dev.mysql.com/doc/mysql/en/String_functions.html
Beware! Make a backup of your database before you try this! (NB: Don't believe everything you read untested)
TIA
-- Robin Lynn Frank - Director of Operations - Paradigm-Omega, LLC
HTH, Wolfram
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
