i used the code to export duplicates to a text file
$sql = "SELECT * FROM phone WHERE phone IN (SELECT phone FROM phone GROUP BY phone HAVING COUNT(id) > 1) ORDER BY phone";
how can i used this in mate to list only the duplicates so i can edit them on the spot?
thank you