if(Condition, ConditionIsTrue, ConditionIsNotTrue)

SELECT depending on condition

select if(3 < 5,'Condition is true','Condition is not true') as ConditionalResult

UPDATE depending on condition

Example – Increment value if below # or reset to 1
"UPDATE MyTable SET
  MyValueA = 1,
  MyValueB = if(MyValueB < 65535, MyValueB + 1, 1) 
 WHERE Something = 5"
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *