filter data

Discuss MySQL Ajax Table Editor

filter data

Postby msavi » Sun Nov 16, 2014 6:55 am

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
msavi
 
Posts: 62
Joined: Tue Oct 12, 2010 10:56 am

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 13 guests

cron