title: Removing text wrapped in parentheses (including parentheses) from MySQL DB column using regex
body: <p>I have observations in a MySql database that have naming schemes like below</p>
  <p><code>foo (bar)</code><br />
  <code>foo (bar 5) (foo)</code><br />
  <code>foo (bar) bar (foobar) foo</code></p>
  <p>I want to delete the text from these observations that are in the parentheses (any character contained not just letters), inclusive of the parentheses so that the below remains</p>
  <p><code>foo</code>
  <code>foo</code>
  <code>foo bar foo</code></p>
  <p>Also realizing some left over whitespace might be annoying if there are multiple matches. Any help on the regex or functions is appreciated</p>