LT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a boolean indicating if one value is less than another.
USAGE
LT(value, value)
Argument Name | Description |
|---|---|
| The two values to compare |
DETAILS
LT() is a function that checks if the first argument is less than the second argument and returns 1 (true) or 0 (false).
If at least one value is a number, a numeric comparison is performed. Thus, a string value is converted into a number when paired with a numeric value.
When both values are strings, the comparison takes into account the current sort order, which might treat uppercase and lowercase letters as equivalent.
A NULL is returned if either argument is NULL.
The function call LT(x, y) behaves in exactly the same manner as the conditional expression x < y.
EXAMPLES
SELECT LT(99, 123), LT(PI(), 3);
+-------------+-------------+
| LT(99, 123) | LT(PI(), 3) |
+-------------+-------------+
| 1 | 0 |
+-------------+-------------+
-- Disable strict mode or the select might throw an error
SET sql_mode = '';
SELECT LT(99, '99a'), LT('99', '99a');
+---------------+-----------------+
| LT(99, '99a') | LT('99', '99a') |
+---------------+-----------------+
| 0 | 1 |
+---------------+-----------------+