title: Delete a string after certain symbol SQlite
body: <p>I have a sqlite dictionary database with table called &quot;eng&quot; and column called &quot;defn&quot;.
  Data in &quot;defn&quot; is like that:</p>
  <blockquote>
  <p>/(v5r,vt) (uk) to pluck/to pick/to tear off</p>
  <p>/(n) (uk) (See ほぞ穴) tenon/cog/dovetail/pivot</p>
  <p>/(adj-no) bilingual/in two languages</p>
  </blockquote>
  <p>What I need is to delete all the symbols after first &quot;)&quot;.
  Result must be something like that:</p>
  <blockquote>
  <p>/(v5r,vt)</p>
  <p>/(n)</p>
  <p>/(adj-no)</p>
  </blockquote>
  <p>I was thinking about using the SUBSTR but the problem is that in each line length of word inside the &quot;()&quot; is different. And /(<em>some word</em>) exist in each string of the column.</p>
  <p>Couldn't someone kindly suggest me the best way to do it? Thank you in advance.</p>