Control Flow Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Control Flow Functions
  4. Using string comparison function with IF
mysql>
mysql> SELECT IF(STRCMP('test','test1'),'no','yes');
+---------------------------------------+
| IF(STRCMP('test','test1'),'no','yes') |
+---------------------------------------+
| no                                    |
+---------------------------------------+
1 row in set (0.00 sec)
mysql>