title: Find control characters in MySQL
body: <p>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</p>
  
  <pre><code>SELECT * FROM Customer WHERE Name = *ControlCharFilter*;
  </code></pre>
  
  <p>in C# it would be</p>
  
  <pre><code>Customer.Where(x =&gt; x.Name.Any(y =&gt; char.IsControl(y));
  </code></pre>