Like
模糊查询
select
s.*
from BIZ_ASSAY_ORDER_SAMPLE s
LEFT JOIN BIZ_ASSAY_ORDER o on o.ID=s.ORDER_ID
WHERE 1=1
<if test="status !=null and status !=''">
AND s.RECORD_STATUS=#{status}
</if>
<if test="sampleNo !=null and sampleNo !=''">
AND s.SAMPLE_NO LIKE '%'||#{sampleNo}||'%'
</if>
关键代码
s.SAMPLE_NO LIKE '%'||#{sampleNo}||'%'