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");
+
Hi
I have more fields with values as
the-object1
the-object2
the-object45
I must to change only the part begins them to other words, example:
"the-object2" must become "an-object2"
Which syntax I can use?
Thanks in advance
--
http://www.spacemarc.it
--
MySQL General Mailing List
For lis
