How can I update values all at once in mysql?

A1WEBSITEPRO QuestionsCategory: MySqlHow can I update values all at once in mysql?
bob asked 12 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

Advanced Programming Made Easy

I hope you enjoyed the article. If I was able to help you please consider buying me a drink.

Drinks

1 Answers
Best Answer
Maximus McCullough answered 12 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

Advanced Programming Made Easy

I hope you enjoyed the article. If I was able to help you please consider buying me a drink.

Drinks