How can I update values all at once in mysql?

A1WEBSITEPRO QuestionsCategory: MySqlHow can I update values all at once in mysql?
bob asked 4 months 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
1 Answers
Best Answer
Maximus McCullough answered 4 months 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