一、条件构造器函数列表
函数名 | 说明 | 说明/例子 |
---|---|---|
allEq | 入参都满足条件 | 例:allEq({"id": 1, "name": "张三", "age": null})--->id = 1 and name = '张三' and age is null |
eq | 等于= | 例:eq("name", "张三") ---> name = '张三' |
ne | 不等于<> | 例:ne("name", "张三") ---> name <> '张三' |
gt | 大于> | 例:gt("age", 18) ---> age > 18 |
ge | 大于等于>= | 例:ge("age", 18) ---> age >= 18 |
lt | 小于< | 例:lt("age", 18) ---> age < 18 |
le | 小于等于<= | 例:le("age", 18) ---> age <= 18 |
between | between 值1 and 值2 | 例:between("age", 18, 30) ---> age between 18 and 30 |
notBetween | not between 值1 and 值2 | 例:notBetween("age", 18, 30) ---> age not between 18 and 30 |
like | like '%值%' | 例:like("name", "张") ---> name like '%张%' |
notLike | not like '%值%' | 例:notLike("name", "张") ---> name not like '%张%' |
likeLeft | like '%值' | 例:likeLeft("name", "张") ---> name like '%张' |
likeRight | like '值%' | 例:likeRight("name", "张") ---> name like '张%' |
notLikeLeft | not like '%值' | 例:notLikeLeft("name", "张") ---> name not like '%张' |
notLikeRight | not like '值%' | 例:notLikeRight("name", "张") ---> name not like '张' |
isNull | 字段 is null | 例:isNull("name") ---> name is null |
isNotNull | 字段 is not null | 例:isNotNull("name") ---> name is not null |
in | 字段 in (v0, v1, ...) | 例:in("age", {18, 19, |