mysql> update updateIfConditionDemo set UserAge =if(UserAge =23,26,UserAge); Query OK, 4 rows affected (0.20 sec) Rows matched: 5 Changed: 4 Warnings: 0