Hi guys,
I'have an SQL database with a lot of email and name.. from user who
registred into.
I'd like to do statistics, about mail adresse after the @, you know the
'domain'.
So i have this :
Id - EMail :
1 - [EMAIL PROTECTED]
12 - [EMAIL PROTECTED]
11 - [EMAIL PROTECTED]
121 - [EMAIL PROTECTED]
52 - [EMAIL PROTECTED]
151 - [EMAIL PROTECTED]
2 - [EMAIL PROTECTED]
How should i extract : tata.com, titi.com, and may by count them ?
If you have an idea you'll be verry happy !
The other way could be to select all email adresse and regex them do ++
count, and them display, but later it'll take to much of time :/
So do you avec any idea ?
--
=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
Nicolas JOURDEN #41100039 - +33 0681940905
http://www.wedoo.com - http://ddx.ovh.org
Programmeur Perl, CGI, Mysql/PostgreSQL, HTML, JavaScript...
=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
