title: SQL select all that is outside of the parentheses
body: <p>I have a bunch of lines in my database that look something like this:</p>
  
  <pre><code>123 'text i want (textidontwant)'
  </code></pre>
  
  <p>and I'm trying to select everything from the database with the text i want only.</p>
  
  <p>I know that I'm supposed to use substring, but I'm not sure how to.</p>
  
  <p>Thanks for the help!</p>