STRCMP(expr1,expr2)
STRCMP()
returns 0
if the strings are the same, -1
if the first argument is smaller than the second according to the current sort order, and 1
otherwise.
SELECT STRCMP('text', 'text2'); +-------------------------+ | STRCMP('text', 'text2') | +-------------------------+ | -1 | +-------------------------+ SELECT STRCMP('text2', 'text'); +-------------------------+ | STRCMP('text2', 'text') | +-------------------------+ | 1 | +-------------------------+ SELECT STRCMP('text', 'text'); +------------------------+ | STRCMP('text', 'text') | +------------------------+ | 0 | +------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/strcmp/