05_値が空の行の検索

概要

• 値が空の行の検索方法をまとめる。

IS NULL, IS NOT NULL

概要

• 値が空かどうかを判定する。

サンプル

SELECT Name FROM country 
WHERE Capital IS NULL;

• 実行結果

MariaDB [world]> SELECT Name FROM country WHERE Capital IS NULL;
+----------------------------------------------+
| Name                                         |
+----------------------------------------------+
| Antarctica                                   |
| French Southern territories                  |
| Bouvet Island                                |
| Heard Island and McDonald Islands            |
| British Indian Ocean Territory               |
| South Georgia and the South Sandwich Islands |
| United States Minor Outlying Islands         |
+----------------------------------------------+
7 rows in set (0.00 sec)