I was looking for exactly the same functionality. Have a look at this thread - it sorted it out for me!

http://forums.mysql.com/read.php?97,...2359#msg-62359

The code I ended up with is:
[code=mysql]
set @myvar = concat('select ?, ?, ?, ?, ?, ?, ?, ?, ?, ? INTO OUTFILE ', "'",'my/path/',now() + 0,'_', bookingID,'_',C ounter, '.email',"'",' FIELDS TERMINATED by \'\r\n\'');
...