title: ORDER BY soundex with WHERE (MySql)
body: <p>Query code:</p>
  
  <pre><code>SELECT *
  FROM example
  WHERE name LIKE '%test%'
  OR SOUNDEX(name) LIKE 'T230%'
  OR SOUNDEX(name) LIKE 'T23%'
  </code></pre>
  
  <p>I want to show first the results matched with <code>WHERE name LIKE '%test%'</code> and after <code>SOUNDEX(name) LIKE 'T230%'</code> and the lasts rows is the result of <code>SOUNDEX(name) LIKE 'T23%'</code></p>
  
  <p>Thank you for the attention.</p>