MySQL Find non-ascii characters using REGEXP

To find non-ascii characters using a SELECT query, run a query similar to the following:
SELECT
    *
FROM
    `mytable`
WHERE
    `column` REGEXP(CONCAT('[', CHAR(128), '-', CHAR(255), ']'))
Did this help you? Please let me know with a comment. Thank you
Posted .

1 comment (RSS)

  1. anonymous

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

Leave a comment