Mybatis-Plus eq ne gt lt ge le分别代表含义 条件构造器

一、条件构造器函数列表 

函数名	说明	说明/例子
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, 20}) ---> age in (18,