update if else mysql

Solutions on MaxInterview for update if else mysql by the best coders in the world

showing results for - "update if else mysql"

1UPDATE prices
2SET final_price= CASE
3   WHEN currency=1 THEN 0.81*final_price
4   ELSE final_price
5END
6

similar questions

update select mysql mysql update mysql if without else mysql update value mysql update query update set mysql mysql else if mysql update from select update information in a mysql column mysql update mysql if else created at and updated at in mysql mysql update inner how to update rows from a table when certain conditions are met in mysql update using case in mysql update select mysql update query in mysql

queries leading to this page

if condition in mysql update query if in update mysql mysql if else condition update query mysql update set if then else mysql update using if mysql update if if condition then select else update mysql mysql update with if statement mysql update set if mysql update if else update if else mysql