MySQL Forums
Forum List  »  MySQL Query Browser

Re: find and replaced
Posted by: Jay Narayan
Date: January 11, 2013 10:31PM

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

Options: ReplyQuote


Subject
Written By
Posted
January 06, 2013 10:26AM
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.