Search equals in table ... Simple?

[Marcusanthonius]

Hello I want to find to equals in one table.

select mailadres from table WERE mailadres == mailadres;
in Mysql...

Am I on the right track?

Thanks

[bad76]

Hi,
is not so simple...

I will do this:
First, count how many mailadres are in the table:

SELECT mailadres,count(*) as num_of_equals FROM table
GROUP BY mailadres
ORDER BY num_of_equals

This query tells you if there are some mailadres with more than one entries.

Then for each mailadres where count()>1 do any action.

I hope this helps you.

bye bye

[Marcusanthonius]

Yes, it worked fine.
I will go on working this out, based on your answers.

Thanks for the quick reply!

Greetings,

Marcus