MySQL Find non-ascii characters using REGEXP
SELECT
query, run a query similar to the following:
SELECT
*
FROM
`mytable`
WHERE
`column` REGEXP(CONCAT('[', CHAR(128), '-', CHAR(255), ']'))
SELECT
query, run a query similar to the following:
SELECT
*
FROM
`mytable`
WHERE
`column` REGEXP(CONCAT('[', CHAR(128), '-', CHAR(255), ']'))
1 comment
SELECT * FROM `table` WHERE NOT HEX(`column`) REGEXP '^([0-7][0-9A-F])*$'
Leave a Reply