MySQL 运算符

算数运算符

+ - * /

除DIV,  x1 div x2

% 取余  x1%x2

MOD 取余 MOD(X1,X2)

注意 

1 + '3xyz'   结果4

1/0 结果NULL

1+NULL 结果NULL

比较运算符

= ， !=， <=>, >, >= ...

IS NULL, IS NOT NULL

BETWEEN AND , NOT BETWEEN

IN, NOT IN

LIKE, NOT LIKE

REGEXP

逻辑运算符

&& 或 AND

|| 或 OR

!或 NOT

XOR 异或 不同为真

可以通过（）改变优先级

---------------------------

例子

SELECT name, name='kylie' FROM user;

SELECT name, name<=>null FROM user;

SELECT name, name IS NOT NULL FROM user;

SELECT id, name, id BETWEEN 1 AND 3 FROM user;

SELECT id, name, id IN(1,4,5) FROM user;

SELECT id, name, name REGEXP '^K' FROM user;

SELECT 1 XOR 0, 0 XOR 1, 0 XOR 0; 结果 1，1，0