SELECT * FROM `采购-菜市场情报地图`
where 1=1
${IF(
index(dz,"省")=-1,"and 省='"+dz+"'",
IF(
INDEX(kz,"市")=-1,"and 市='"+kz+"'",
INDEX(az,"区")!=-1,"and 区='"+az+"'","and 区 = '"
)
)}
这个SQL如何进行省市区过滤