常用詞解釋?zhuān)?/p>
where WHERE 語(yǔ)句，拼接 + WHERE 條件
and AND 語(yǔ)句，拼接 + AND 字段=值
andNew AND 語(yǔ)句醒串，拼接 + AND (字段=值) （新的括號(hào)）
or OR 語(yǔ)句，拼接 + OR 字段=值
orNew OR 語(yǔ)句，拼接 + OR (字段=值)
eq 等于=
allEq 基于 map 內(nèi)容等于=
ne 不等于<>
gt 大于>
ge 大于等于>=
lt 小于<
le 小于等于<=
like 模糊查詢(xún) LIKE
notLike 模糊查詢(xún) NOT LIKE
in IN 查詢(xún)
notIn NOT IN 查詢(xún)
isNull NULL 值查詢(xún)
isNotNull IS NOT NULL
groupBy 分組 GROUP BY
having HAVING 關(guān)鍵詞
orderBy 排序 ORDER BY
orderAsc ASC 排序 ORDER BY
orderDesc DESC 排序 ORDER BY
exists EXISTS 條件語(yǔ)句
notExists NOT EXISTS 條件語(yǔ)句
between BETWEEN 條件語(yǔ)句
notBetween NOT BETWEEN 條件語(yǔ)句
addFilter 自由拼接 SQL
last 拼接在最后咱筛，例如：last("LIMIT 1")
