一个表 ,结构如下id name hid1 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' 这样的
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' 这样的
SELSECT * FROM one WHERE hid not in (123, 456)
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 吗?
SELSECT * FROM 一个表 WHERE `hid` IN (123,456);
SELSECT * FROM 一个表 WHERE `hid`=123 OR `hid`=456;
SELSECT * FROM 一个表 WHERE `hid` REGEXP '^(123|456)$';
都可以
SELSECT * FROM one WHERE hid in (123, 456)
SELSECT * FROM one WHERE hid not in (123, 456)
SELSECT * FROM one WHERE hid = 123 AND hid = 456; 对吗?
hid 会同时等于 123 和 456 吗?
不好意思,应该是这样SELSECT * FROM one WHERE hid = 123 OR hid = 456;
SELSECT * FROM one WHERE hid != 123 AND hid != 456;