MySQL variables and file path

[mhalloran]

See the post below ...

[mhalloran]

Anyone?

The simpler version...

SET @file_path := "/home/filename.txt";

SELECT *
INTO OUTFILE 
"@fle_path" 
FIELDS TERMINATED BY '|'  

LINES TERMINATED BY '\r\n'  

FROM tablename;

Why can't the file path be a variable? Is there a work around for this problem. I really don't want to rewrite the entire script in another language because of a single problem that seems so simple.

Thanks for the help.

[mhalloran]

OK -

Quick bump before I rewrite the script. Does anyone have anything I can try before I spend three hours converting it?

Is there a good (and active) MySQL that I can post this problem on?

Thanks