查询的某字段不为空的写法
SELECT
i.zch zch,
i.zzmc zzmc,
i.longtitude qydzX,
i.latitude qydzY
FROM
ind_qyzt_jbxx i
WHERE i.sfgsqy = '1'
AND (i.zch IS NOT NULL
AND i.zch != '')
查询的某字段不为空的写法
SELECT
i.zch zch,
i.zzmc zzmc,
i.longtitude qydzX,
i.latitude qydzY
FROM
ind_qyzt_jbxx i
WHERE i.sfgsqy = '1'
AND (i.zch IS NOT NULL
AND i.zch != '')