to what purpose? just to highlight them? delete them? move them around?
the data is not normalised so anything you do will involve more work.
but if you just want a list excluding duplicates use a union query
Code:
select mobile1 as mobile from myTable
union select mobile2 from myTable
union select mobile3 from myTable
this will automatically remove duplicates