April 15

Update a column value, replacing part of a string

here is how we can replace partial of the string on all rows in MySQL: 

UPDATE my_table_name
SET my_field_name = REPLACE(my_field_name, 'unwanted-string', 'new-string');

Promotional / Featured products: Contents Settings Layouts
Experteer's Scripting: Coding - Experts Only
Send us a message. We will reply as soon as we can.

Save your professional blogger profile.

Join our blogger group and earn more income.

Sign up Log in