運算子
|
字串
|
編號
|
日期
|
「列舉」
|
布林值
|
equals
|
X
|
X (預設)
|
X
|
X (預設)
|
X (預設)
|
not
|
X
|
X
|
X
|
X
|
X
|
like
|
X (預設)
|
||||
not like
|
X
|
||||
in
|
X
|
X
|
|||
not in
|
X
|
X
|
|||
>
|
X
|
X
|
X
|
||
>=
|
X
|
X
|
X
|
||
<
|
X
|
X
|
X
|
||
<=
|
X
|
X
|
X
|
||
null
|
X
|
X
|
X
|
X
|
X
|
not null
|
X
|
X
|
X
|
X
|
X
|
介於 (between)
|
X (預設)
|
||||
yesterday
|
X
|
||||
last week
|
X
|
||||
last month
|
X
|
||||
last quarter
|
X
|
||||
last year
|
X
|
||||
today
|
X
|
||||
this week
|
X
|
||||
this month
|
X
|
||||
this quarter
|
X
|
||||
this year
|
X
|
||||
tomorrow
|
X
|
||||
next week
|
X
|
||||
next month
|
X
|
||||
next quarter
|
X
|
||||
next year
|
X
|