mysql判断字段不等于空 mysql判断字段不等于空 LENGTH(mobile)>0 或者 xx is not null SELECT id,mobile FROM ziliao WHERE LENGTH(mobile)>0