MySQL: csv output

$q = «select ...where something IN ('...','...','...')»

mysql database -B -h192.168.198.67 -u username -ppassword -e «START TRANSACTION WITH CONSISTENT SNAPSHOT; $q;COMMIT;»

1
| sed 's/\t/,/g'

>> output_file.csv