Using IF with float point value : IF « Control Flow Functions « MySQL Tutorial

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

mysql>
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>