Web Hosting Talk







View Full Version : Export Email Addresses Mysql


mikee_n
08-12-2009, 05:32 PM
I've done this before but cant remember how i done it ! - I want to export the email address's from all my users in my mysql database to a plain .txt file -- I ran a query before but cant remember what it was. When i ran the query it listed all the email address from all my users in the mysql query windows in phpmyadmin

Kohrar
08-12-2009, 07:37 PM
Hmmm... If you want to list all the email address of all your users by running something like this:


SELECT `emailAddresses` FROM `users`


If you want to save the list somewhere, you can use the INTO OUTFILE clause.