- select * from crm_yesoo_leads where 1=1
- ${if(len(project_c_chubu) == 0,""," and project_c_chubu = '" + project_c_chubu + "'")}
- ${if(len(project_m_qudao) == 0,"", " and project_m_qudao = '" + project_m_qudao + "'")}
- ${if(len(project_add_2) == 0,""," and project_add_2 = '" + project_add_2 + "'")}
- ${if(len(s_keyword) == 0,""," and CONCAT(project_name,project_desc,project_c_name,project_c_mobile,project_c_tel,project_c_qq,project_c_other) like '%" + s_keyword + "%'")}
- order by project_s_time desc
|
