一个字段实现key value 同时搜索

    <select id="findMediaSourceList" parameterType="com.gildata.task.platform.api.query.third.MediaSourceQuery" resultType="com.gildata.task.platform.api.dto.TaskMediaSourceDTO">
        SELECT * FROM (select code AS 'abbr' , concat_ws ("-",code,values) AS 'value' from task_media_source)A
        <where>
            <if test="query.name != null  and query.name != ''"> and value like concat('%', #{query.name}, '%')</if>

        </where>
    </select>

这样作为搜索条件的name 既可以为key,也可以为值