Tabula:
CREATE TABLE `streets` (
`id` int(10) unsigned NOT NULL auto_increment,
`street` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)
Kverijs:
SELECT DISTINCT s.street, (SELECT id FROM streets WHERE street = s.street ORDER BY id ASC LIMIT 1 ) as id
FROM streets s;