Syntax
------

<=

Description
-----------

Less than or equal operator. Evaluates both SQL expressions and returns 1 if
the left value is less than or equal to the right value and 0 if it is not, or
NULL if either expression is NULL. If the expressions return different data
types, (for instance, a number and a string), performs type conversion.

When used in row comparisons these two queries return the same results:

SELECT (t1.a, t1.b) <= (t2.x, t2.y) 
FROM t1 INNER JOIN t2;

SELECT (t1.a < t2.x) OR ((t1.a = t2.x) AND (t1.b <= t2.y))
FROM t1 INNER JOIN t2;

Examples
--------

SELECT 0.1 <= 2;
+----------+
| 0.1 <= 2 |
+----------+
|        1 |
+----------+

SELECT 'a'<='A';
+----------+
| 'a'<='A' |
+----------+
|        1 |
+----------+

URL: https://mariadb.com/kb/en/less-than-or-equal/