SELECT * FROM `采购-菜市场情报地图`

where 1=1 

 ${IF(

  index(dz,"省")=-1,"and 省='"+dz+"'",

  IF(

  INDEX(kz,"市")=-1,"and 市='"+kz+"'",

  IF(

  INDEX(az,"区")!=-1,"and 区='"+az+"'","and 区 = '"

  )

  )

 )}

这个SQL如何进行省市区过滤