mysql select id title_en from countries where currency is null ---- --

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
mysql> select id, title_en from countries where currency is null;
+----+--------------------------------------+
| id | title_en |
+----+--------------------------------------+
| AD | Andorra |
| AQ | Antarctica |
| AT | Austria |
| BE | Belgium |
| BG | Bulgaria |
| BL | Saint-Barthelemy |
| BS | Bahamas |
| CD | Congo - Kinshasa |
| CY | Cyprus |
| DK | Denmark |
| EH | Western Sahara |
| ES | Spain |
| FI | Finland |
| FR | France |
| GB | United Kingdom |
| GF | French Guiana |
| GP | Guadeloupe |
| GR | Greece |
| HM | Heard Island and McDonald Islands |
| HU | Hungary |
| IE | Ireland |
| IQ | Iraq |
| IT | Italy |
| LT | Lithuania |
| LV | Latvia |
| ME | Montenegro |
| MM | Myanmar |
| MQ | Martinique |
| MT | Malta |
| NL | Netherlands |
| NP | Nepal |
| PL | Poland |
| PM | Saint Pierre and Miquelon |
| PT | Portugal |
| RE | Reunion |
| RO | Romania |
| SE | Sweden |
| SI | Slovenia |
| SJ | Svalbard and Jan Mayen |
| SV | El Salvador |
| TF | French Southern Territories |
| TL | East Timor |
| UM | United States Minor Outlying Islands |
| US | United States |
| VA | Vatican |
+----+--------------------------------------+
45 rows in set (0.00 sec)