场景:表中有一个字段数据是以这种形式存储,想查询包含01的数据
代码
List<ParameterPurchaseLimitConf> selectAllEffectiveModuleConfineProductOrgInfos(@Param("moduleConfine") String moduleConfine);
<select id="selectAllEffectiveModuleConfineProductOrgInfos" resultType="com.yonghui.yh.rme.srm.ordercenter.dao.entity.ParameterPurchaseLimitConf">
select <include refid="Base_Column_List"/>
from parameter_purchase_limit_conf
where `status` = 1
<if test="moduleConfine != null and moduleConfine != ''">
and FIND_IN_SET(#{moduleConfine,jdbcType=VARCHAR},module_confine)
</if>
</select>
select *
from
parameter_purchase_limit_conf
where
`status` = 1
and FIND_IN_SET('01',module_confine)