title: Deleting part of a string in MYSQL
body: <p>I want to delete part of a string found in a particular field.  </p>
  
  <p>For example, the entry in the field could be "01365320<strong>APS</strong>". The "APS" is what I am looking at deleting.   </p>
  
  <p>My question is, should I use:</p>
  
  <pre><code>SELECT SUBSTRING_INDEX('fieldname','APS', 1)
  </code></pre>