How can I select rows based on a string containing ascii code 0x02?

Question

I would like to find all rows in a table containing the character 0x02.
For clarity, I'm looking for something like:

SELECT * FROM table WHERE column LIKE '% 0x02%'

+3

MonoThreaded May 01, '12 at 15:29

2 answers

I would go with

SELECT * FROM table WHERE LOCATE(X'02', column) > 0

+3

David gorsline May 01, '12 at 15:41

Cylindric · Accepted Answer · 2012-05-01T15:33:51+0000

Hexadecimal literals? A %-0x25

SELECT * FROM table WHERE column LIKE 0x250225

The validation guide reminds me that the syntax is 0xnot strictly an SQL standard, so maybe use insteadX''

SELECT * FROM table WHERE column LIKE X'250225'