title: How to remove part of string in mysql?
body: <p>In one table of my database I have strings which looks like this one:</p>
  
  <pre><code>sometext-othertext
  </code></pre>
  
  <p>How to remove the text including dash with SELECT statement so the result to be just <code>sometext</code>?</p>