UPDATE table SET col1=REPLACE(col1,'beta.','www.');
Would do what you would need.
On Sun, Aug 16, 2009 at 11:14 AM, m i l e s <magicmiles@stripped> wrote:
> I'm a little rusty in my SQL statements, and I'm not all that certain that
> this can be done.
> IF I have a field with the contents like:
> where 2 is the record ID value. And I need to change the contents of that
> field to read:
> How would I accomplish this with a native SQL statement ?
> I was thinking that I'd just export the contents of the table, and do a
> text manipulation against the field, only to realize that the record id
> value is embedded in the link of the field. Which means that I can't change
> the record id value at all. Or turn off the auto increment of the keyfield
> because it will invalidate the records when its turned back on....
> Any suggestions as to how I might clean this up ????
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1