title: SQL Match Special Characters Regexp
body: <p>I'm looking for an SQL statement that will return only rows of my table whose <code>Name</code> field contains special characters (excluding underscores).</p>
  
  <p>I've tried:  </p>
  
  <pre><code>SELECT * FROM 'table' WHERE Name REGEXP '^[!#$%&amp;()*+,\-./:;&lt;=&gt;?@[\\\]^`{|}~]+$'
  </code></pre>
  
  <p>But no dice, this returns an empty result set (despite there being rows I specifically added with Name fields containing <code>%, $, and #</code> characters).</p>