eq(等于)和ne(不等于)
gt(大于)和ge(大于等于)
lt(小于)和le(小于等于)
between (
between 值1 and 值2
)
notBetween(
not between 值1 and 值2
)
in(
字段 in (值1,值2,值3,……)
)
notIn(
字段 not in (值1,值2,值3,……)
)
eq(等于)和ne(不等于)
gt(大于)和ge(大于等于)
lt(小于)和le(小于等于)
between (
between 值1 and 值2
)
notBetween(
not between 值1 and 值2
)
in(
字段 in (值1,值2,值3,……)
)
notIn(
字段 not in (值1,值2,值3,……)
)