|
運算子
|
字串
|
編號
|
日期
|
「列舉」
|
布林值
|
|---|---|---|---|---|---|
|
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
|