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]
