Export a column to a file on MYSQL

If you need to export the contents of a column to a file, please do as below.

SELECT City, Zipcode FROM my_table INTO OUTFILE 'export.dat'