##创建表Foobar:
CREATE TABLE `Foobar` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
##插入下面3行数据:
+---+----+---+
| a | b | c |
+---+----+---+
| 1 | 1 | 3 |
| 1 | 2 | 3 |
| 1 | 23 | 1 |
+---+----+---+
##使用OR:
SELECT a, b, c
FROM Foobar
WHERE a=b
OR a=c;
结果为:
+---+----+---+
| a | b | c |
+---+----+---+
| 1 | 1 | 3 |
| 1 | 23 | 1 |
+---+----+---+
##使用IN:
SELECT a, b, c
FROM Foobar
WHERE a IN (b, c);
结果为:
+---+----+---+
| a | b | c |
+---+----+---+
| 1 | 1 | 3 |
| 1 | 23 | 1 |
+---+----+---+