罗列与Where子句相关的常见操作:

等与不等:
=,某个列的值是否为XXX
!=、<>、^=,某个列的值是否不为XXX

大于?小于?:
>,大于(不包含当前值)
<,小于(不包含当前值) >=,大于等于(包含当前值)
<=,小于等于(包含当前值) 范围: in,在列表内 not in,不在列表内 between A and B,在A到B的区间(范围)内 not between A and B,不在A到B的区间(范围)内 正则表达式: like '<正则>‘,是正则描述的规则

关于空值(NULL):
is null,确认空
is not null,确认不为空
————————————————————
Done。

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装