Re: find and replaced
REPLACE() might be where you want to start
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace
as long as your replacing all occurances of '?' to '.' you could probably do it with 1 update;
update table_name
set products_name = REPLACE(products_name, '?', '.'),
products_description REPLACE(products_description, '?', '.');
Also if the table is quite large then it would probably be a good idea to add in limits using the where clause
Subject
Written By
Posted
Re: find and replaced
January 11, 2013 10:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.