南宁市 韦力平:asp查询字段问题
来源:百度文库 编辑:杭州交通信息网 时间:2024/05/09 08:00:19
怎么查询数据库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