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");
+-----------------------------------+
| replace("the-object1","the","an") |
+-----------------------------------+
| an-object1 |
+-----------------------------------+
1 row in set (0.09 sec)
ok.
I will use the replace function in Update query.
--
http://www.spacemarc.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]