http://www.icyphoenix.com/viewtopic.php?f=35&t=7124&p=48814#p48814
-----------------------------------
Lopalong
Sat 24 Apr, 2010 09:18

Re: Export Email Addresses To A CSV File
-----------------------------------
[b]MySQL Forums?.[/b]  :roll: 

[i]This assumes that your DB prefix is ip_ and that you don't have more than a 1000 users.[/i]

[b]Go To[/b]

phpMyAdmin > YOUR DB > SQL > Run this Query Code:

[code linenumbers=false]SELECT COUNT( * ) AS `Rows` , `user_email`
FROM `ip_users`
GROUP BY `user_email`
ORDER BY `user_email`
LIMIT 0 , 1000[/code]


> Query results operations > Export > CSV > GO