mysql - 在主键区间中选择 SQL

Question

在学校我们看到你可以这样选择:

SELECT *
FROM BLALBLA
WHERE id=1 AND id = 2 AND id=3 AND id=4

但是我们该怎么做:

SELECT
FROM BLABLA
WHERE id = 1 to 4

谢谢金人

Answer 1

有几种方法

1) 如果 id 字段是整数。

SELECT *
FROM BLALBLA
WHERE id between 1 and 4

SELECT *
FROM BLALBLA
WHERE id => 1 AND id =< 4

SELECT *
FROM BLALBLA
WHERE id IN (1,2,3,4)

2) 如果 id 是 varchar

SELECT *
FROM BLALBLA
WHERE id IN ('1','2','3','4')