This would give you a list of all users that have entered things more than
once; However, it would not give you all the rows that are duplicated.
SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) > 1
Hope this helps!
Daniel Von Fange
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Tom Churm wrote:
> hi,
>
> i have 2 questions that i badly need answered. i use phpmyadmin, but
> any answers containing SQL syntax should work in this app...
>
> 1)
> this should be simple but i don't know it. i use the following mysql
> table field as the Key for my tables:
>
> "id int(
hi,
i have 2 questions that i badly need answered. i use phpmyadmin, but
any answers containing SQL syntax should work in this app...
1)
this should be simple but i don't know it. i use the following mysql
table field as the Key for my tables:
"id int(10) unsigned NOT NULL auto_increment,"
