Hello all : I want to show a duplicate value between three columns

[Matin_Murad]

إظهار القيمة المكررة بين ثلاثة أعمدة

 

[CJ_London]

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

select mobile1 as mobile from myTable
union select mobile2 from myTable
union select mobile3 from myTable

this will automatically remove duplicates