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 = 'MY' order by rank asc limit 0,100 Surnames > M > MY > MYA

Surnames > M > MY > MYA

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
MY MYA MYC MYD MYE MYG MYH MYI MYJ MYK MYL MYN MYO MYR MYS MYT MYU MYV

Full Surname List Starting with MYA(Alphabetical)

MYA
MYALL
MYAT
MYATT

Top 100 Surnames in the 2010 US Census starting with MYA

SurnameCountRankWiki?
MYATT 3149 10234 no
MYA 186 97671 no
MYALL 170 105079 no
MYAT 110 149395 no