conteo de telefonos repetidos en 2 columnas.

[huesos52]

Código mysql:

UPDATE contactos INNER JOIN 
(SELECT tel1, count(tel1) as repetidos
FROM contactos 
group by tel1)
t1 ON t1.tel1 = contactos.tel1
INNER JOIN  
(SELECT tel2, count(tel2) as repetidos
FROM contactos 
group by tel2)
t2 ON t2.tel2 = contactos.tel2 SET contactos.telefonos_repetidos = (t1.repetidos + t2.repetidos);
 

No la he probado.