title: MySQL - How to parse string value inside of INSERT to find a sub-string
body: <p>I'm getting a string value back from an external application that is supposed to be providing an email address. However, this string value sometimes is providing a display name that goes along with the email address. I only need the email address, which is inside the &lt;brackets&gt;, so I think I need to do some sort of sub-string or <code>SELECT</code> clause, inside of my <code>INSERT</code> statement. </p>
  
  <p>Here is what my <code>INSERT</code> statement looks like, along with the test data: </p>
  
  <pre><code>INSERT INTO tblInquiry
  (fldInquiryFromEmail)
  VALUES ('"\'Tim Lastname\'" &lt;timm@testCCaddcompany.com&gt;')
  </code></pre>