select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'MR' order by rank asc limit 0,100 Surnames > M > MR > MRS

Surnames > M > MR > MRS

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
MA MB MC ME MG MH MI MJ MK ML MN MO MP MR MU MW MY
MRA MRK MRN MRO MRS MRU

Full Surname List Starting with MRS(Alphabetical)

MRSIC
MRSNY

Top 100 Surnames in the 2010 US Census starting with MRS

SurnameCountRankWiki?
MRSIC 164 108199 no
MRSNY 147 118185 no