Re: regexp for unicode control chars

[Rick James]

This might work:
SELECT * FROM tbl WHERE HEX(msg) RLIKE '[[:cntrl:]]';

Are you using the character set "ucs2"?
<opinion>
For non-ascii text, "utf8" is essentially the only character set to use.
</opinion>

Please point me to a reference on the list of "control codes" you want to catch.

This will find any records with a utf8 code of the form (in hex) of 'C3xx':
SELECT * FROM tbl WHERE HEX(msg) RLIKE '^(..)*C3';

If you are really using ucs2, then something like
SELECT * FROM tbl WHERE HEX(msg) RLIKE '^(....)*xxxx';
will catch any msg with the control code xxxx (suitable hex).