Using IF() function to compare numbers : IF « Control Flow Functions « MySQL Tutorial

1. MySQL Tutorial
2. Control Flow Functions
3. IF

mysql>
mysql> SELECT IF(15>10,'Yup','Nope');
+------------------------+
| IF(15>10,'Yup','Nope') |
+------------------------+
| Yup                    |
+------------------------+
1 row in set (0.02 sec)

mysql>
mysql> SELECT IF(5>10,'Yup','Nope');
+-----------------------+
| IF(5>10,'Yup','Nope') |
+-----------------------+
| Nope                  |
+-----------------------+
1 row in set (0.00 sec)

mysql>