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 correct syntax for my column is "where column like"% ...% ".

Thanks!

Answer 1

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

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