title: Having problems matching whitespace whith MySql REGEX
body: <p>I'm trying to match all phones in a database which don't match with the format of this example '(11) 1234-5678'.</p>
  
  <p>I'm having troubles defining a regexp because of the whitespace, I have done this tests:</p>
  
  <pre><code>SELECT '(11) 1234-5678' REGEXP "\([0-9]{2}\)" -&gt; 1
  SELECT '(11) 1234-5678' REGEXP "\([0-9]{2}\).*" -&gt; 1
  SELECT '(11) 1234-5678' REGEXP "\([0-9]{2}\) " -&gt; 0
  SELECT '(11) 1234-5678' REGEXP "\([0-9]{2}\)[:blank:]" -&gt; 0
  SELECT '(11) 1234-5678' REGEXP "\([0-9]{2}\)[:space:]" -&gt; 0
  </code></pre>
  
  <p>I have absolutely no idea of why I can't get mysql to match a whitespace.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>I'm using mysql 5.5.24</p>