title: using substring with regex mysql
body: <p>I am trying to get year (yyyy) from text/string in the column "title" but for some reason can't get following query to work:</p>
  
  <pre><code>select substring(title,LOCATE(REGEXP '[(][0-9]{4}[)]',title),4) from videos
  </code></pre>
  
  <p>title column has following values:</p>
  
  <pre><code>abc abc 2001 abc
  xyz (2002) xyz
  </code></pre>
  
  <p>Any assistance will be appreciated.</p>