运算符 算术运算符： 运算符有+, -, *, %(mod函数), /(div函数)。        
比较运算符：        
数字作为浮点数比较，字符串以不区分大小写的方式进行比较。
mysql> select 10 between 10 and 20, 9 between 10 and 20;+----------------------+---------------------+| 10 between 10 and 20 | 9 between 10 and 20 |+----------------------+---------------------+| 1 | 0 |+----------------------+---------------------+
regexp则用正则表达式进行匹配，如： mysql> select 'abcdef' regexp 'ab', 'abcdefg' regexp 'k';+----------------------+----------------------+| 'abcdef' regexp 'ab' | 'abcdefg' regexp 'k' |+----------------------+----------------------+| 1 | 0 |+----------------------+----------------------+
逻辑运算符： mysql中包含的逻辑运算符：
分别对几种逻辑运算符进行描述：
mysql> select not 0, not 1 , not null;+-------+-------+----------+| not 0 | not 1 | not null |+-------+-------+----------+| 1 | 0 | null |+-------+-------+----------+
mysql> select 1 and 1, 0 and 1, 3 and 1, 1 and null;+---------+---------+---------+------------+| 1 and 1 | 0 and 1 | 3 and 1 | 1 and null |+---------+---------+---------+------------+| 1 | 0 | 1 | null |+---------+---------+---------+------------+
mysql> select 1 or 0, 0 or 0, 1 or null, 1 or 1, null or null;+--------+--------+-----------+--------+--------------+| 1 or 0 | 0 or 0 | 1 or null | 1 or 1 | null or null |+--------+--------+-----------+--------+--------------+| 1 | 0 | 1 | 1 | null |+--------+--------+-----------+--------+--------------+
mysql> select 1 xor 1, 0 xor 0, 1 xor 0, 0 xor 1, null xor 1;+---------+---------+---------+---------+------------+| 1 xor 1 | 0 xor 0 | 1 xor 0 | 0 xor 1 | null xor 1 |+---------+---------+---------+---------+------------+| 0 | 0 | 1 | 1 | null |+---------+---------+---------+---------+------------+
位运算符： mysql5.0支持的位运算符：
分别介绍这几种位运算：
mysql> select 2&3, 2&3&4;+-----+-------+| 2&3 | 2&3&4 |+-----+-------+| 2 | 0 |+-----+-------+
mysql> select 2|3, 2|3|4;+-----+-------+| 2|3 | 2|3|4 |+-----+-------+| 3 | 7 |+-----+-------+
mysql> select 2^3;+-----+| 2^3 |+-----+| 1 |+-----+
mysql> select ~1, ~18446744073709551614;+----------------------+-----------------------+| ~1 | ~18446744073709551614 |+----------------------+-----------------------+| 18446744073709551614 | 1 |+----------------------+-----------------------+
mysql> select 100>>3;+--------+| 100>>3 |+--------+| 12 |+--------+
mysql> select 100<<3;+--------+| 100<<3 |+--------+| 800 |+--------+
运算符的优先级：       
具体的运算符的细节可参考官网：
http://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
不吝指正。