MySQL查找空字段或不为空的字段
MySQL查询空字段数据:
select * from table where id = '';
select * from table where isnull(age);
MySQL查询不为空字段的数据(非空数据):
select * from table where age <> '';
select * from table where age != '';
MySQL查询空字段数据:
select * from table where id = '';
select * from table where isnull(age);
MySQL查询不为空字段的数据(非空数据):
select * from table where age <> '';
select * from table where age != '';