Mysql LESS THAN OR EQUAL TO
From w3cyberlearnings
Contents |
MySQL Less Than or Equal To Function
This functions checks for less than or equal to.
Syntax Less Than or Equal To
a <= b;
Return
Returns 1 when the function is true, or returns 0 otherwise.
Example 1
mysql> SELECT 3 <= 4 t1, 3 <= 1 t2, 1 <= 3 t3; +----+----+----+ | t1 | t2 | t3 | +----+----+----+ | 1 | 0 | 1 | +----+----+----+ 1 row in set (0.01 sec)
Example 2
mysql> SELECT score,student_name FROM
-> myscore WHERE score <= 34;
+-------+--------------+
| score | student_name |
+-------+--------------+
| 30 | Bob |
| 34 | Kim |
+-------+--------------+
2 rows in set (0.00 sec)
