mysql> describe rest;
+---------------+-------------+------+-----+---------+----------------+
| Field |
Type | Null | Key | Default |
Extra |
+---------------+-------------+------+-----+---------+----------------+
| ID |
int(11) | | PRI | 0 |
auto_increment |
| Name |
varchar(40) | YES | | NULL
| |
| FoodRating |
int(11) | YES |
| NULL | |
| DecorRating |
int(11) | YES | | NULL
| |
| ServiceRating | int(11) | YES | | NULL
| |
| Cost |
int(11) | YES |
| NULL | |
| Neighbor |
varchar(80) | YES | | NULL
| |
| City | varchar(40) | YES |
| NULL | |
| Street |
varchar(40) | YES | | NULL
| |
| Phone |
varchar(15) | YES | | NULL
| |
| Description |
text | YES |
| NULL | |
| Features |
text | YES |
| NULL | |
| Cuisine |
varchar(40) | YES | | NULL
| |
+---------------+-------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql> select distinct SUBSTRING(city,
instr(city,'DC,')+3 ,5 ) from rest where city like
'%DC,%';
+------------------------------------------+
| SUBSTRING(city, instr(city,'DC,')+3 ,5 ) |
+------------------------------------------+
| 20001 |
| 20002 |
| 20003 |
| 20004 |
| 20005 |
| 20006 |
| 20007 |
| 20008 |
| 20009 |
| 20015 |
| 20016 |
| 20020 |
| 20024 |
| 20036 |
| 20037 |
| 20090 |
| 20463 |
| 20566 |
+------------------------------------------+
18 rows in set (0.14 sec)