where条件查询怎样查询几个ID以外的数据

[zc88888]

比如我要在product数据表里把字段categoryid为1、3、5以外的数据读出来，这个查询条件怎么写？

[三石-gary]

select * from product where categoryid in(1,3,5)

[shenzhenNBA]

select * form where categoryid in (1,3,5)
或
select * form where categoryid <> 1 or categoryid <> 3 or categoryid <> 5

[shenzhenNBA]

select * form tb where categoryid not in (1,3,5)
或
select * form tb where categoryid <> 1 or categoryid <> 3 or categoryid <> 5

[三石-gary]

http://topic.csdn.net/u/20090911/22/2a7c5a0f-4476-4dfa-86ab-ca0ef80bf46d.html

[三石-gary]

[Quote=引用 4 楼 zsx841021 的回复:]

http://topic.csdn.net/u/20090911/22/2a7c5a0f-4476-4dfa-86ab-ca0ef80bf46d.html
[/Quote]
我觉得这个里面的方法更好

[shenzhenNBA]

O你已经提供表名了,修改一下

select * form product where categoryid not in (1,3,5)
或
select * form product where categoryid <> 1 or categoryid <> 3 or categoryid <> 5