民用三分的闸板阀:asp查询字段问题
来源:百度文库 编辑:查人人中国名人网 时间:2024/03/29 10:36:44
怎么查询数据库B表中C字段不为空???
select * from news where pic<>null order by id desc 不好使
select * from news where pic<>null order by id desc 不好使
换成select * from news where pic<>"" order by id desc 试试
select * from news where pic is not null order by id desc