title: Equivalent of explode() to work with strings in MySQL
body: <p>In MySQL, I want to be able to search for <code>'31 - 7'</code>, when another value = <code>'7 - 31'</code>.  What is the syntax that I would use to break apart strings in MySQL?  In PHP, I would probably use <code>explode(' - ',$string)</code> and put them together.  Is there a way to do this in MySQL?  </p>
  
  <p>Background: I'm working with sports scores and want to try games where the scores are the same (and also on the same date) - the listed score for each team is backwards compare to their opponent's database record.  </p>
  
  <p>The ideal MySQL call would be:</p>
  
  <pre><code>Where opponent1.date  = opponent2.date
    AND opponent1.score = opponent2.score
  </code></pre>
  
  <p>(<code>opponent2.score</code> would need to be <code>opponent1.score</code> backwards).</p>