title: Sorting mySql results using LIKE '%variable%'
body: <p>I have a search form on my website that allows users to search for employees in a company. I'm using the input to search a table in a mySql DB. My SELECT state is here:</p>
  
  <pre><code>SELECT title, uid FROM table_data 
  WHERE title LIKE '%$search_name%' AND blog_id = 6 
  ORDER BY title ASC LIMIT 50
  </code></pre>
  
  <p>Currently, a search for 'Jon' would result in some like:</p>
  
  <pre><code>Angela Jones
  Dejonas Lucero
  Ernesto Jon
  Jon White
  Rick Jonston
  </code></pre>
  
  <p>Is there a way to have it sort in this order?</p>
  
  <pre><code>search_name%
  %search_name
  %search_name%
  
  Jon White
  Ernesto Jon
  Angela Jones
  Dejonas Lucero
  Rick Jonston
  </code></pre>