title: MySQL Select data separated strings
body: <p>I am trying to select a record using the LIKE function. However, it does not show results if there are characters in between. I want it to select data that contains those strings. For example:</p>
  
  <pre><code> $value = "Mark Anthony";
   $qry ="SELECT * FROM students WHERE name LIKE '%$value%'";
  </code></pre>
  
  <p>returns these results:</p>
  
  <pre><code> John Mark Anthony
   Mark Anthony Philipps
  </code></pre>
  
  <p>but I also want to have results like these</p>
  
  <pre><code> Mark James Anthony
   Mark Gabriel Anthony Fernandez
   Marko Julian Anthonyo
  </code></pre>
  
  <p>Any ideas?
  UPDATE: 'Mark' must be before 'Anthony'</p>