Copy MySQL table field to notepad line by line

Hello Friends

I need your help . I want to know how can i copy all the email address from my mysql table "users" to a notepad file line by line ie , one record or one email address in one line .
My database name is friends .
MY table name is users
And , Field name is email .

Please tell me how to do that .

 

can someone help me out ? Please ..

 

just copy and export the email field dude.

 

How to copy and export that single field ?

 

I don't know of any single command or operation to accomplish this - but here are two ways to approach it. One way is to use the SQL command

SELECT EMAIL FROM USERS ORDER BY EMAIL ASC

Run it so that you can see the output - then copy the output and paste it into a notepad file.
Or export as CSV, import into Excel or Open Office Spreadsheet, delete the columns you don't want, keeping only the "email" column.

 

In Phpmyadmin, run this query

select email from users

Use the export link at page bottom to export the result, and only email will appear in the result.

Select CSV format for saving the data.

 

Thanks a lot friends . Your reply really helped me .

 

Select Email From Users Order By Email Asc