MySql handy commands

MySql handy commands

Replace field data with another value

UPDATE table_name SET field = replace(field,'string-to-find','string-that-will-replace-it');

 
 

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *