search

Home  >  Article  >  Database  >  MySQL finds records containing non-ASCII character values

MySQL finds records containing non-ASCII character values

大家讲道理
大家讲道理Original
2016-11-12 09:46:511048browse

SELECT * FROM my_table WHERE NOT HEX(my_column) REGEXP '^([0-7][0-9A-F])*$';
 
-- 相反的，找出只包含ASCII字符的记录
 
SELECT * FROM my_table WHERE HEX(my_column) REGEXP '^([0-7][0-9A-F])*$';


Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql genealogy table to query all descendants of a personNext article：Mysql genealogy table to query all descendants of a person

Related articles

See more