How to display the desired field from mysql database in one column?

Question

SQL

Can you please tell me the sql query to display the required field in one column.
There is a user base, you need to extract all email addresses into one column in order to export them later
. How to do this correctly?
I try like this
SELECT * FROM `xf_user` WHERE `email` LIKE '' ORDER BY `email` ASC fails
select `xf_user` from users mysite `email` - doesn't output either

Answer 1

SELECT email FROM `xf_user`;