できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
IN
式 IN (値1,…)
SELECT Name FROM country
WHERE Region IN ('British Islands', 'Antarctica');
MariaDB [world]> SELECT Name FROM country WHERE Region IN ('British Islands', 'Antarctica');
+----------------------------------------------+
| Name |
+----------------------------------------------+
| Antarctica |
| French Southern territories |
| Bouvet Island |
| United Kingdom |
| Heard Island and McDonald Islands |
| Ireland |
| South Georgia and the South Sandwich Islands |
+----------------------------------------------+
7 rows in set (0.00 sec)