SELECT * FROM sp_activity_Contractor WHERE activityId = #{param1} and contact is not null and contact != '' limit 0,1 SELECT A.id, A.activityId, B.sponsor as fullName, A.contact, A.phone, A.address, A.nature, A.experienceYear, A.intro, A.organizationCode, A.addTime, A.updateTime FROM sp_activity_Contractor A,sp_activity B WHERE A.activityId=B.id and activityId = #{param1} order by id delete FROM sp_activity_Contractor WHERE activityId = #{activityId} limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.id,'') AS id ,a.fullName ,a.contractorType ,a.contact ,a.phone ,a.province ,a.city ,a.area ,CONCAT(p.fullName,c.fullName,ar.fullName) AS pcaName ,a.address ,a.organizationCode ,a.orgUrl ,a.adminTel ,a.email ,a.applyTime ,a.isFreeze FROM sp_activity_Contractor a INNER JOIN base_region p ON p.id = a.province INNER JOIN base_region c ON c.id = a.city LEFT JOIN base_region ar ON ar.id = a.area WHERE 1=1 AND ( a.fullName like CONCAT('%', #{keywords}, '%') OR a.phone like CONCAT('%', #{keywords}, '%') OR a.contact like CONCAT('%', #{keywords}, '%') OR a.address like CONCAT('%', #{keywords}, '%') OR a.adminTel like CONCAT('%', #{keywords}, '%') OR a.organizationCode like CONCAT('%', #{keywords}, '%') ) AND a.phone = #{phone} AND a.organizationCode = #{organizationCode} AND a.contractorType = #{contractorType} AND a.province = #{sProvince} AND a.city = #{sCity} AND a.area = #{sArea} AND a.applyTime >= #{startDate} AND #{endDate} >= a.applyTime