1

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?

scubasteve
  • 2,718
  • 4
  • 38
  • 49

0 Answers0