outfile with rawurldecode?

[DKY]

I have some outfile code with a remark (SUBMIT_SSREMARK) in it and the remark has the html characters instead of foreign characters

$QuerySSSANDBOX = "SELECT 
CONCAT(
	RPAD(ID,32,' '),
	RPAD(NAV_PN,25,' '),
	RPAD(SUBMIT_SSREMARK,200,' ')
) 
INTO OUTFILE '../../../SSSANDBX' 
LINES TERMINATED BY '\r\n' 
FROM TBLSSSANDBOX";

How do I use rawurldecode to decode these in the oufile?

[dalecosp]

Since [man]rawurldecode/man is a PHP function, you can't using it in conjunction with the SQL outfile directive.

You could return the SQL data to PHP, say, in an array or string, call [man]rawurldecode/man on it, and then write it to a file with [man]fwrite/man and friends.

There might also be an SQL alternative to [man]rawurldecode[/man], but, off the top of my head, I can't think what it might be.

[DKY]

okay so any ideas what the array option would look like? Can an array hold 500,00 ish data points in it? That might be my best bet as I can't find a mysql solution for html encoding...