以前做过数量少的,有三个字段的,按照阶乘计算排列了 6 种,这 5 个字段顶不住阿,阶乘算完直接 120 种
<where>
<if test="searchValue != null and searchValue != ''">
and CONCAT(result.deviceType, code, ifnull(model,'')) like CONCAT('%', #{searchValue}, '%')
or CONCAT(result.deviceType, ifnull(model,''), code) like CONCAT('%', #{searchValue}, '%')
or CONCAT(code, result.deviceType, ifnull(model,'')) like CONCAT('%', #{searchValue}, '%')
or CONCAT(code, ifnull(model,''), result.deviceType) like CONCAT('%', #{searchValue}, '%')
or CONCAT(ifnull(model,''), code, result.deviceType) like CONCAT('%', #{searchValue}, '%')
or CONCAT(ifnull(model,''), result.deviceType, code) like CONCAT('%', #{searchValue}, '%')
</if>
</where>
请问有除了 es 的更好的解决办法吗?顶不住了