title: Redshift SQL REGEXP_SUBSTRING
body: <p>I have a string of the following type:</p>
  <pre><code>'Wall/2.0 (Brick; Stone; GR-222) Dust/537.8 (Hole, like Big) Imp/2.0.898.23'
  </code></pre>
  <p>From this above string, I want to extract the first occurance of the word between <code>(</code> and <code>;</code>. In the above string, the result should be <code>Brick</code></p>
  <p>I tried the following query(<code>Redshift</code>) using regexp_substr:</p>
  <pre><code>select regexp_substr('Wall/2.0 (Brick; Stone; GR-222) Dust/537.8 (Hole, like Big) Imp/2.0.898.23', '\\((.*);', 0, 1, 'e);
  </code></pre>
  <p>But, this outputs <code>Brick; Stone</code>.</p>
  <p>Can someone please help me to write a proper regex expression, such that the query output should result a string between <code>(</code> and first occurance of <code>;</code>. <code>Brick</code> should be the ooutput in the above string</p>