Mega Code Archive

 

Categories / MySQL Tutorial / Control Flow Functions

 

Using IF() function to compare numbers

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>