民用三分的闸板阀:asp查询字段问题

来源:百度文库 编辑:查人人中国名人网 时间:2024/03/29 10:36:44
怎么查询数据库B表中C字段不为空???
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