export result from select statement

[LAMP]

Hi guys,
I wonder how to store to csv or txt file result from SELECT query?  
not a whole table nor database. Just results from SELECT query.
Usually I use MySQL Query Browser and Export feature, but in this  
case I don't have access with MySQL Query Browser. Though, I have a  
command line access.
I found on one place something like
#SELECT 2+2 into outfile '/path/to/specific/directory/test.csv';
Though, it doesn't work?!?

Thanks.