MySQL select long length of host list

I have data in table with host list, I want to select from a long list of host records and filter to generate a short list of hosts.

host1                  
host2                  
host1:host2:host3:host4
host5:host6            
host5:host6:host7:host8
开发者_如何学Chost9                  
host10:host11          

From the above data, I want to select only these records

host1:host2:host3:host4
host5:host6:host7:host8
host9                  
host10:host11

Because host1 and host2 are part of third record, I want to skip the first two records and select third one.

Because host5:host6 is part of the next row, I want to skip this row.

Is it possible in MySQL?