How to query MySQL for fields containing null characters

Question

I have a MySQL table with a text column. Some rows have null characters (0x00) as part of this text column (along with other characters).

I am looking for a query that will return all rows containing any null characters for this column, but I cannot figure out how the proper syntax for my "where column like '%...%'" clause.

Thank you!

score 13 · Answer 1 · edited May 23 '17 at 11:53

13

Right after I submitted the question, a suggested link to this related question provided my answer: Query MySQL with unicode char code

WHERE column LIKE CONCAT("%", CHAR(0x00 using utf8), "%");

edited May 23 '17 at 11:53

Community

1
1

answered Jun 08 '13 at 00:48

CJS

1,455
1
13
17

score 2 · Answer 2 · answered Oct 29 '19 at 12:37

2

The following worked for me...

WHERE column LIKE "%\0%";

answered Oct 29 '19 at 12:37

Drew

1,420
1
11
14

How to query MySQL for fields containing null characters

2 Answers2