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 > MIJ

Surnames > M > MI > MIJ

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 MIJ(Alphabetical)

MIJAL
MIJANGO
MIJANGOS
MIJARES
MIJAREZ
MIJATOVIC

Top 100 Surnames in the 2010 US Census starting with MIJ

SurnameCountRankWiki?
MIJARES 3259 9912 no
MIJANGOS 1204 21648 no
MIJANGO 294 67126 no
MIJATOVIC 265 73215 no
MIJAREZ 223 84136 no
MIJAL 189 96368 no