一般常用like
license_number LIKE '%沪%'
#mybatis
license_number LIKE concat('%',#{searchKey},'%')
查询字段值中是否包含某个字符/字符串,
前提字段中的值是以半角逗号,分隔的形式保存,find_in_set
#字段值中逗号分隔开的某一个值要全匹配
#brand = ('宝马,奥迪,奔驰,沃尔沃')
find_in_set('奥迪', brand)
#mybatis
find_in_set(#{brandCode}, brand)
查询字段值是否包含在某字符列表中,IN
#series = '君威'
series IN ( 'Q50L【国产】','别克GL8','君威' )
#mybatis
series in
<foreach collection="seriesList" item="item" separator="," open="(" close=")">
#{item}
</foreach>
字段中值不是以逗号分隔形式保存,查询字段中是否包含某字符,REGEXP
#license_number = '京AE8601'
license_number REGEXP '(沪|赣|豫|京)'
#mybatis
license_number REGEXP
<foreach collection="areaList" item="item" separator="|" open="(" close=")">
#{item}
</foreach>