I have several fields, one of which is a BLOB. I want to SELECT the fields and return the results to the browser, and then dump the contents of the BLOB into a file on the server. I’m struggling with how to do this in one query. The on_linear_array field is the BLOB.
SELECT
id
,model_type
,on_linear_array
INTO DUMPFILE
‘dump.txt’
FROM station
return the results to the browser??
isn’t there an application language in between mysql and the browser? like php or something?
Ha! Yes, Mr. Literal, I’ll be using PHP to print the results to the browser. 
okay, so php retrieves the data from the database and saves the blob to the file
i don’t do php or i’d help you further
The query is the problem; it’s putting all of the results into the file. I figured I’d written it incorrectly. Hmmm…