83版穆念慈买肉:asp查询字段问题
来源:百度文库 编辑:高校问答 时间:2024/05/12 18:21:29
怎么查询数据库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