>=
Greater than or equal operator. Evaluates both SQL expressions and returns 1 if the left value is greater 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;
SELECT 2 >= 2; +--------+ | 2 >= 2 | +--------+ | 1 | +--------+ SELECT 'A' >= 'a'; +------------+ | 'A' >= 'a' | +------------+ | 1 | +------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/greater-than-or-equal/