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

Surnames > M > MI > MIF

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
MI MIA MIC MID MIE MIF MIG MIH MII MIJ MIK MIL MIM MIN MIO MIQ MIR MIS MIT MIU MIV MIW MIX MIY MIZ

Full Surname List Starting with MIF(Alphabetical)

MIFFLIN
MIFSUD
MIFTARI

Top 100 Surnames in the 2010 US Census starting with MIF

SurnameCountRankWiki?
MIFFLIN 1172 22095 no
MIFSUD 732 31587 no
MIFTARI 157 111988 no