SELECT
BRANCH_CODE,
BRANCH_NAME,
iae.FACE_AMT,
iae.SPEC,
iae.BEGIN_NO,
iae.END_NO,
(iae.PASS_BEN*iae.SPEC) AS RESERVE_COUNT,
iae.CODE,
iae.TOTAL_AMT,
DATE_FORMAT(SIGN_TIME, '%Y-%m-%d %H:%i:%S') AS ALLOT_TIME
FROM
invoice_applys ia
where 1=1
<if test = 'paramMap.BRANCH_CODE != null and paramMap.BRANCH_CODE != ""'>
and find_in_set(ia.BRANCH_CODE, ${paramMap.BRANCH_CODE}) > 0
</if>
<!--传入的BRANCH_CODE要加‘’,如:'005,009,118'find_in_set函数只要ia.BRANCH_CODE存在于${paramMap.BRANCH_CODE}中,就返回大于0的数-->
mysql find_in_set函数使用
最新推荐文章于 2024-09-10 14:55:57 发布