title: Trim String using a multi-character delimiter
body: <p>Similar to <a href="https://stackoverflow.com/questions/64186247/how-to-abbreviate-row-of-strings-with-a-multiple-character-delimiter">this solution</a>, I need to edit the value of a column, on several rows of a table, based on the presence of a string (not a single character delimiter) within the value of that column.  Unlike the other solution, I am not trying to replace or add characters, nor am I trying to save data AFTER the string.  In the corrupted data string:</p>
  <pre><code>good stuff in front'abc d' bad stuff I want to get rid of
  </code></pre>
  <p>I need a MySQL statement to find <code>'abc d'</code> in the string, and then just return <code>good stuff in front</code>.</p>