できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
BETWEEN
式 BETWEEN 値1 AND 値2
SELECT * FROM city
WHERE Population BETWEEN 7000000 AND 8000000;
MariaDB [world]> SELECT * FROM city WHERE Population BETWEEN 7000000 AND 8000000;
+------+--------+-------------+----------+------------+
| ID | Name | CountryCode | District | Population |
+------+--------+-------------+----------+------------+
| 456 | London | GBR | England | 7285000 |
| 1025 | Delhi | IND | Delhi | 7206704 |
| 1532 | Tokyo | JPN | Tokyo-to | 7980230 |
| 1891 | Peking | CHN | Peking | 7472000 |
+------+--------+-------------+----------+------------+
4 rows in set (0.01 sec)