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

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.