title: MySQL RegularExpression (Limiter not working)
body: <p><strong>NOTICE TO THE MODS: DON'T DELETE/ DON'T CLOSE</strong>
  I asked this question earlier and the mods closed it because they thought it was similar to a question by another user. I have looked at the thread that they referred me to and it doesn't contain the kind of numeric problems that I have. That thread is <a href="https://stackoverflow.com/questions/4123455/how-do-i-match-an-entire-string-with-a-regex">How do I match an entire string with a regex?</a></p>
  <hr />
  <p><strong>My Question/Issue</strong>:
  REGEXP is returning a false positive.</p>
  <pre><code>SELECT '123456' REGEXP '[0-9]{1,4}' AS Test;
  </code></pre>
  <p>Based on what I've read, the part with the curly brace {1,4} means minimum of 1 occurrence and no more than 4. But from the above , the occurrence of the range [0-9] is more than 4 and yet the query returns a 1 instead of a 0. I've attached a screenshot. What am I missing? Thanks.</p>
  <p><a href="https://i.stack.imgur.com/i2Ape.jpg" rel="nofollow noreferrer">Screenshot of the example in Workbench</a></p>