How do I export the email addresses to a csv file format?
Thanks,
Dave
SOLVED Export Email Addresses To A CSV File
Subject: Re: Export Email Addresses To A CSV File
MySQL Forums?. :roll:
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
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]
SELECT COUNT( * ) AS `Rows` , `user_email`
FROM `ip_users`
GROUP BY `user_email`
ORDER BY `user_email`
LIMIT 0 , 1000
FROM `ip_users`
GROUP BY `user_email`
ORDER BY `user_email`
LIMIT 0 , 1000
> Query results operations > Export > CSV > GO
Subject: Re: Export Email Addresses To A CSV File
You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment. :roll:
Page 1 of 1
You cannot post new topicsYou cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Powered by Icy Phoenix based on phpBB
Generation Time: 0.9623s (PHP: 2% SQL: 98%)
SQL queries: 15 - Debug Off - GZIP Enabled