DB ์ฟผ๋ฆฌ operator¶
operation ์์ฑ¶
<condition> ์์์ operation ์์ฑ์ ์กฐ๊ฑด์ ์ฐ์ฐ์๋ฅผ ์ง์ ํฉ๋๋ค. ์๋์ ๊ฐ์ ์ฐ์ฐ์๋ฅผ ์ฌ์ฉํ ์ ์์ต๋๋ค.
| ์ฐ์ฐ์ | ์๋ฏธ | ์ง์ ๋ฒ์ |
|---|---|---|
| equal | column = (var or default) | >= 2.0.0 |
| more | column >= (var or default) | >= 2.0.0 |
| gte | same as more |
>= 2.0.0 |
| excess | column > (var or default) | >= 2.0.0 |
| gt | same as excess |
>= 2.0.0 |
| less | column <= (var or default) | >= 2.0.0 |
| lte | same as less |
>= 2.0.0 |
| below | column < (var or default) | >= 2.0.0 |
| lt | same as below |
>= 2.0.0 |
| regexp | column REGEXP (var or default) | >= 2.0.0 |
| notregexp | column NOT REGEXP (var or default) | >= 2.0.0 |
| not_regexp | same as notregexp |
>= 2.0.0 |
| notequal | column != (var or default) | >= 2.0.0 |
| not_equal | same as notequal | >= 2.0.0 |
| notnull | column is not null | >= 2.0.0 |
| null | column is null | >= 2.0.0 |
| like_prefix | column like 'var or default%' | >= 2.0.0 |
| like_head | same as like_prefix |
>= 2.0.0 |
| like_suffix | column like '%var or default' | >= 2.0.0 |
| like_tail | same as like_suffix |
>= 2.0.0 |
| like | column like '%var or default%' | >= 2.0.0 |
| notlike | column NOT LIKE '%var or default%' | >= 2.0.0 |
| notlike_prefix | column NOT LIKE 'var or default%' | >= 2.0.0 |
| notlike_head | same as notlike_prefix |
>= 2.0.0 |
| notlike_suffix | column NOT LIKE '%var or default' | >= 2.0.0 |
| notlike_tail | same as notlike_suffix |
>= 2.0.0 |
| search | ์ฌ์ฉ๋ ๋จ์ด๋ค์ ์๋์ผ๋ก ๋ถ๋ฆฌํ์ฌ ๊ทธ ๊ฐฏ์๋งํผ LIKE % ์กฐ๊ฑด์ ๋ง๋ค์ด ์ค๋๋ค. | >= 2.0.0 |
| in | column in (var or default) | >= 2.0.0 |
| notin | column not in (var or default) | >= 2.0.0 |
| null | column IS NULL | >= 2.0.0 |
| notnull | column IS NOT NULL | >= 2.0.0 |