updating multiple columns in a table with multiple conditions in mysql : Is it possible to run an update query on multiple columns with multiple conditions in MySQL? 



[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/dRlrv.png

For example above is the structure of a table myTable, where I want to run a query like:
`UPDATE TABLE myTable set value = 25 where id = 1 and price = 12 where pp_flag = 8`.

Just wondering if I can do this in the same query in MYSQL.


Thanks 