Operator Index
Symbols | A | B | C | D | E | I | L | N | O | R | X
Symbols
[index top]
-
!
!=
%
&
&&
>
->
>>
->>
>=
<
<>
<<
<=
<=>
*
+
/
:=
=
^
|
||
~
A
[index top]
AND
B
[index top]
BETWEEN
BINARY
C
[index top]
CASE
结束时的案例值
结束时
EXPR1 = EXPR2 时为空,否则为空 EXPR1 结束
column->>path
column->path
D
[index top]
DIV
E
[index top]
最小值和最大值之间的 table 达式
expr IN()
expr LIKE pat
最大值和最小值之间的 table 达式
expr NOT IN()
不喜欢拍
expr NOT REGEXP pat
expr NOT RLIKE pat
expr REGEXP pat
expr RLIKE pat
expr1 类似于 expr2 的声音
I
[index top]
IN()
IS
IS boolean_value
不是 boolean_value
不为空
IS NULL
L
[index top]
LIKE
LIKE '_A%'
LIKE 'pattern'
喜欢...逃生
N
[index top]
氮%
模数
NOT
NOT IN()
NOT LIKE
NOT REGEXP
NOT RLIKE
O
[index top]
OR
R
[index top]
REGEXP
RLIKE
X
[index top]
XOR