How do I export the email addresses to a csv file format?

Thanks,

Dave

MySQL Forums?.  

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

Go To

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




> Query results operations > Export > CSV > GO

Lopalong wrote: [View Post]

MySQL Forums?.  

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

Go To

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

Code: [Download] [Hide] [Select]

Code: [Download] [Show]

SELECT COUNT( * ) AS `Rows` , `user_email`
FROM `ip_users`
GROUP BY `user_email`
ORDER BY `user_email`
LIMIT 0 , 1000

> Query results operations > Export > CSV > GO

Thanks a bunch Lopalong.  That is exactly what I needed.

You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment.

Lopalong wrote: [View Post]

You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment.

Done!  Sorry.