Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-----
> From: spacemarc [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 17, 2006 9:27 AM
> To: Mike Kruckenberg
> Cc: mysql@lists.mysql.com
> Subject: Re: Update query
2006/11/17, Mike Kruckenberg <[EMAIL PROTECTED]>:
If it's values you are updating you can use the replace() string
function to do something like this:
update table1 set field1=replace(field1,'the','an');
To demonstrate:
mysql> select replace("the-object1","the","an");
+
