mysql语法中有哪些比较运算符

mysql语法中有哪些比较运算符，下面编程教程网小编给大家简单介绍一下各种运算符！

比较运算符：

=
<=>
<> (!=)
<= >=
>
IS NULL
IS NOT NULL
LEAST
GREATEST
BETWEEN . . . AND. . . 
ISNULL
IN
NOT IN
LIKE
REGEXP