Dark Launch

MySQL Find non-ascii characters using REGEXP

To find non-ascii characters using a SELECT query, run a query similar to the following:
SQL
SELECT
*
FROM
`mytable`
WHERE
`column` REGEXP(CONCAT('[', char(128), '-', char(255), ']'))

Comments


  1. SELECT * FROM `table` WHERE NOT HEX(`column`) REGEXP '^([0-7][0-9A-F])*$'