Mysql常用函数的汇总,可看下面文章
https://cloud.tencent.com/developer/article/1641021
STRCMP(expr1,expr2)
SELECT STRCMP('text', 'text2'); # -1
SELECT STRCMP('text2', 'text'); # 1
SELECT STRCMP('text', 'Text'); # 0
SELECT strcmp(123, 123); # 0
SELECT strcmp(123, 122); # 1
SELECT strcmp(123, 124); # -1
SELECT strcmp('abc', 'Abc'); # 0
SELECT strcmp('abc', 'abb'); # 1
SELECT strcmp('abc', 'abd'); # -1