Chinaunix

标题: BETWEEN and 后面如何再接IN？？ [打印本页]

作者: 小木虫子 时间: 2010-04-13 10:27
标题: BETWEEN and 后面如何再接IN？？
比如

BETWEEN 1 and 3 and IN (5,8,9)

这样用，报错。

作者: 小木虫子 时间: 2010-04-13 10:31
搞定。

作者: ruochen 时间: 2010-04-13 16:19
and？ or 吧

root@localhost:test 16:20:38>select * from t1;
+---+
| a |
+---+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+---+
9 rows in set (0.00 sec)

root@localhost:test 16:20:43>select * from t1 where a between 1 and 3 or a in (5,6,7);
+---+
| a |
+---+
| 1 |
| 2 |
| 3 |
| 5 |
| 6 |
| 7 |
+---+
6 rows in set (0.00 sec)

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)