一:算术运算符:
运算符 描述
运算符 | 描述 | 表达式形式 |
> | 大于 | x1>x2 |
< | 小于 | x1<x2 |
= <=> |
等于 | x1=x2 x1<=>x2 |
!=(<>) | 不等于 | x1!=x2 x1<>x2 |
>= | 大于等于 | x1>=x2 |
<= | 小于等于 | x1<=x2 |
between and | 存在指定范围 | x1 between m and n |
is null | 为空 | x1 is null |
in | 存在指定集合内 | x1 in (value1,value2,value3) |
like | 通配符匹配 | x1 like expression |
regexp | 正则表达式匹配 | x1 regexp regularepres |