How to search in blob binary wise, and how to export data binary wise
One way...

SELECT ... FROM ... WHERE HEX(blob_col) REGEXP '(..)*0038A7';


The (..)* skips over any number of pairs of the hex digits.

For dumping, see mysqldump --hex-blob (not good for csv)

See SELECT ... INTO OUTFILE