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.

Featured Post

Low-tech Tools Can Fight Land Corruption, Experts Say

Technological solutions to prevent land corruption require resources, but they do not have to be expensive, land rights experts said Tuesday...