concatenate in SQL query

[DANDARSMASH]

Hello. I'm making a routine to run daily in SQL Workbench. I want the exported file to have curdate() added to the name for organizational purposes.

SELECT
  d.emailaddress,
  d.fullname,
  d.address,
  d.city,
  d.state,
  d.zip,
  d.makepayabletoname,
  d.makepayabletoaddress,
  d.makepayabletocity,
  d.makepayabletostate,
  d.makepayabletozip,
  p.filenumber,
  p.paymentstatus,
  p.paymentamount,
  p.paymentdate
INTO OUTFILE '/tmp/' CURDATE();.'.csv'
FIELDS TERMINATED BY  ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '/\n'
FROM payments p
JOIN dbase d
ON p.filenumber = d.filenumber
WHERE p.paymentstatus = 'PENDING'
AND p.paymentdate = CURDATE();

The trouble line is: INTO OUTFILE '/tmp/' CURDATE();.'letters.csv' I want it to output to /tmp/2013-06-11letters.csv but I can't figure out how to concatenate.

"Any sufficiently advanced technology is indistinguishable from magic" [Arthur C. Clark]</td></tr></table>

 

[DANDARSMASH]

As an independent query, the following works fine. It does not work when i plug it into my query in the previous post.

SELECT
  CONCAT('/tmp/',DATE_FORMAT(curdate(), '%Y-%m-%d'),'letters.csv') AS your_date;

"Any sufficiently advanced technology is indistinguishable from magic" [Arthur C. Clark]</td></tr></table>