MySQL: update a field only if condition is met

by

Yes!

Here you have another example:

UPDATE prices
SET final_price= CASE
   WHEN currency=1 THEN 0.81*final_price
   ELSE final_price
END

This works because MySQL doesn’t update the row, if there is no change, as mentioned in docs:

If you set a column to the value it currently has, MySQL notices this
and does not update it.

More Related Contents:

  1. MySQL, update multiple tables with one query
  2. MySQL update table based on another tables value
  3. UPDATE multiple rows with different values in one query in MySQL
  4. Multiple Updates in MySQL
  5. UPDATE multiple tables in MySQL using LEFT JOIN
  6. MySQL error code: 1175 during UPDATE in MySQL Workbench
  7. MySQL – UPDATE query with LIMIT
  8. How do write IF ELSE statement in a MySQL query
  9. mysql after insert trigger which updates another table’s column
  10. How to prepend a string to a column value in MySQL?
  11. MySQL update a joined table
  12. MySQL/SQL: Update with correlated subquery from the updated table itself
  13. MySql update two tables at once
  14. Using an IF Statement in a MySQL SELECT query
  15. What are differences between INSERT and UPDATE in MySQL?
  16. Table is ‘read only’
  17. MySql – Way to update portion of a string?
  18. MySQL Error: Incorrect usage of UPDATE and LIMIT
  19. Does MySQL overwrite a column of same value on update?
  20. MySQL UPDATE syntax with multiple tables using WHERE clause
  21. Count with IF condition in MySQL query
  22. mySQL UPDATE query returns “0 rows affected”
  23. MySQL UPDATE and SELECT in one pass
  24. How to create and insert a JSON object using MySQL queries?
  25. The best way to remove value from SET field?
  26. MySQL: How do I use delimiters in triggers?
  27. Update MySQL with if condition
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields
  30. MySQL update statement to store ranking positions

Leave a Comment