Export MySQL query to a file

the Main phrase is

Select ......... where ...........  {INTO OUTFILE 'C:\\file_name.csv'}