Ternary Operator if( , , )

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"