ilmari

mysql> select name from school_region where name != '' order by name;
+------------------+
| name             |
+------------------+
| East             |
| East Midlands    |
| London           |
| North East       |
| North West       |
| Northern Ireland |