conteo de telefonos repetidos en 2 columnas.

[huesos52]

Código mysql:

UPDATE (select tel1 from contactos union select tel2 from contactos) as c INNER JOIN 
(SELECT t1.tel1 as tel, count(t1.tel1) as repetidos
FROM (select tel1 from contactos union select tel2 from contactos)t1
GROUP BY t1.tel1)t2
ON t2.tel = c.tel1
SET contactos.telefonos_repetidos = t2.repetidos;
 

Está tampoco la he probado