How can I update values all at once in mysql?

A1WEBSITEPRO Questions › Category: MySql › How can I update values all at once in mysql?

bob asked 7 years ago

I want to update table rows in mysql but I want to update them all at once. How do I do that?

How can I update values all at once in mysql? was last modified: December 25th, 2016 by bob

Question Tags: update rows, update tabls

1 Answers

Best Answer

Maximus McCullough answered 7 years ago

You can update multiple rows in your database using this syntax.

UPDATE `table_name` SET `field_name` = replace(same_field_name, \'unwanted_text\', \'wanted_text\');

Answer for How can I update values all at once in mysql? was last modified: December 25th, 2016 by Maximus McCullough