title: MySQL Regex - Find where there are 10 numbers in a row in a field
body: <p>I need to find records where there are 10 numbers in a row in the field. e.g. 1234567890, 8884265555 etc.  The field will contain text as well so I need to see if any 10-digit strings exist anywhere within the field.</p>
  
  <p>I have got this far...</p>
  
  <pre><code>SELECT * FROM `comments` WHERE detail REGEXP '[0-9]{10}'
  </code></pre>
  
  <p>My that returns where there 10 numbers <em>anywhere</em> in the field instead of all in a row.  I am trying to detect phone numbers.  Thanks!</p>