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.
Post a Comment

Featured Post

Updated Coupons / promo codes for Google Apps for Work / Business

To redeem: 1. Sign up for Google Apps   2. Go to your billing settings  3. Choose your payment plan  4. Enter your promo code ...