SELECT *
FROM `table_test`
WHERE textname REGEXP ‘[^ -~]‘ =1
列出英文字段记录
SELECT *
FROM `table_test`
WHERE textname REGEXP ‘[^ -~]‘ !=1
列出中文字段记录
select username from cdb_members where username regexp ‘[/u4e00-/u9fa5]+’!=1
SELECT *
FROM `table_test`
WHERE textname REGEXP ‘[^ -~]‘ =1
列出英文字段记录
SELECT *
FROM `table_test`
WHERE textname REGEXP ‘[^ -~]‘ !=1
列出中文字段记录
select username from cdb_members where username regexp ‘[/u4e00-/u9fa5]+’!=1