I'm trying to create a query that will filter on the first bytes of a blob field's data. My googling is not turning up anything and my first attempt does not work as I had hoped.
WHERE `data` LIKE '%1F 8B 08 00 00%'
Or
WHERE `data` LIKE '%1F8B080000%'
Is it even possible to filter on the contents of BLOB content?