Find control characters in MySQL

Question

What is the best way to find control characters within a string in MySQL? I have a table and want to get all records, that contain control characters. Something like

SELECT * FROM Customer WHERE Name = *ControlCharFilter*;

in C# it would be

Customer.Where(x => x.Name.Any(y => char.IsControl(y));

score 8 · Accepted Answer · answered Feb 09 '15 at 14:51

8

MySQL supports regular expressions with POSIX character classes:

SELECT * FROM Customer WHERE Name RLIKE '[[:cntrl:]]+'

There's more information here.

answered Feb 09 '15 at 14:51

Ed Gibbs

25,924
4
46
69

score -1 · Answer 2 · answered Feb 09 '15 at 14:49

-1

SELECT * FROM Customer WHERE Name = "%ControlCharFilter%";

or are you looking for something more complex?

answered Feb 09 '15 at 14:49

jdu

581
2
3

5

Sorry, I beleive you have tottaly misunderstood what OP wants – apomene Feb 09 '15 at 14:50

Find control characters in MySQL

2 Answers2