Apr 12, 2018

Return all rows where COLUMN contains non-ASCII characters in MySQL

select * from TABLE where COLUMN regexp '[^ -~]';


For non-printable ASCII characters such as newline.