民用三分的闸板阀:asp查询字段问题
来源:百度文库 编辑:查人人中国名人网 时间:2024/04/30 00:00:06
怎么查询数据库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