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 list
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);
, November 17, 2006 9:27 AM
To: Mike Kruckenberg
Cc: mysql@lists.mysql.com
Subject: Re: Update query in order to modify some fields
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