问一个SQL查询的问题

[cc_qiu]

一个表 ，结构如下

id name hid

1 lisa 123
2 wangwu 456
3 jia 789
4 you 110


一个表，我想查询hid字段等于 123和456的怎么写呢，
这个表hid不等于123和不等于456的数据

查询hid =123,456的

查询hid 不等于 123,456的

正常查询都是这样 SELSECT * FROM one WHERE hid='123' 这样的

[cc_qiu]

[xuzuning]

SELSECT * FROM one WHERE hid in (123, 456)
SELSECT * FROM one WHERE hid not in (123, 456)

[xuzuning]

引用 3 楼 littlebo01 的回复:

SELSECT * FROM one WHERE hid = 123 AND hid = 456;
SELSECT * FROM one WHERE hid != 123 AND hid != 456;

不要开玩笑，你自己都不懂脑子的？
SELSECT * FROM one WHERE hid = 123 AND hid = 456; 对吗？
hid 会同时等于 123 和 456 吗？

[salmonl]

SELSECT * FROM one WHERE hid = 123 AND hid = 456;
SELSECT * FROM one WHERE hid != 123 AND hid != 456;

[一念工作室]

 SELSECT * FROM one WHERE hid='123'  or hid='456'

[ahxjolin]

参考 or and in 关键字

[PHP小蚂蚁]

in 和 not in 解决

[赵成伟Oo]

引用 3 楼 salmonl 的回复:

SELSECT * FROM one WHERE hid = 123 AND hid = 456;
SELSECT * FROM one WHERE hid != 123 AND hid != 456;

别误人子弟

[DavidSun2014]

使用in,not in就可以解决了
SELSECT * FROM one WHERE hid in (123, 456)
SELSECT * FROM one WHERE hid not in (123, 456)

[salmonl]

引用 4 楼 xuzuning 的回复:

[quote=引用 3 楼 littlebo01 的回复:]

SELSECT * FROM one WHERE hid = 123 AND hid = 456;
SELSECT * FROM one WHERE hid != 123 AND hid != 456;

不要开玩笑，你自己都不懂脑子的？ SELSECT * FROM one WHERE hid = 123 AND hid = 456; 对吗？ hid 会同时等于 123 和 456 吗？[/quote] 不好意思，应该是这样

SELSECT * FROM one WHERE hid = 123 OR hid = 456;
SELSECT * FROM one WHERE hid != 123 AND hid != 456;