SELECT *, CONCAT(ZRDATE, ',', zrequester_id, ',', ZPROD_TYPE) AS ZLONGFROM loan_listWHERE 1 = 1 /*AND zrdate >= '${startdate}' AND zrdate <= '${enddate}'*/ AND LEFT(zrdate, 10) >= '${startdate}' and LEFT(zrdate, 10) <='${enddate}'AND zdel_flag IS NULL -- 新增的条件,只查询zdel_flag为空的记录