How to sort list by domain?

[Anon]

I want to sort email list by domain like yahoo.com or aol.com or hotmail.com. What kind of syntax I should use to complish the sorting?

order by or group by or what?

[Anon]

Hi,

Well what language are you intending you use, e.g.ASP, PHP, JSP, etc. I am a Microsoft programmer so I would say maybe ASP or .NET but the choice is yours. Now back to your question. You can easily sort them if they are stored in some sort of database.

If possible, please include more details on your query.

Enigma

[Anon]

where is the email list comming from? a db? array? text file? do you have any example of your code?

[Anon]

In fact, list is currently located in different folders under directory supposed T1. But I plan to upload them into mysql table. Then sort them by domain and store in mysql table.

Such as [e-mail]
[e-mail]
............@.com

I will use mysql and PHP.

Any ideas?

[Anon]

currently these list are text file, but many small .txt file. I haven't had code. Just test small portion of list by "order by" or "group by", didn't work well.

I plan to upload them into mysql table, then use some coding to sort them. Just need some suggestions and ideas.

Thanks