Control Flow Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Control Flow Functions
  4. Using IF with float point value
mysql>
mysql> SELECT IF(0.1,1,0);
+-------------+
| IF(0.1,1,0) |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT IF(0.1<>0,1,0);
+----------------+
| IF(0.1<>0,1,0) |
+----------------+
|              1 |
+----------------+
1 row in set (0.00 sec)
mysql>