For example, to find some records that contain Chinese characters, use the MySQL Regular Expression query condition AsciiMySQLSELECT * FROMmy_tableWHERENOTHEX (my_column) REGEXP ^ ([0-7] [0-9A-F]) * $; -- On the contrary, find the record that only contains ASCII characters: SELECT * FROMmy_tableWHEREHEX (my_column) REGEXP
For example, to find some records that contain Chinese characters, use the MySQL Regular Expression query condition Ascii MySQL SELECT * FROM my_table where not hex (my_column) REGEXP '^ ([0-7] [0-9A-F]) * $'; -- On the contrary, find the record that only contains ASCII characters: SELECT * FROM my_table where hex (my_column) REGEXP
For example, to find some records that contain Chinese characters, use the MySQL Regular Expression query conditions.
Ascii MySQL
SELECT * FROM my_table where not hex (my_column) REGEXP '^ ([0-7] [0-9A-F]) * $'; -- opposite, SELECT * FROM my_table where hex (my_column) REGEXP '^ ([0-7] [0-9A-F]) * $ ';