title: Use REPLACE() to ORDER BY a mySQL SELECT alphanumerically when special characters are present
body: <p>I had done several different searches on SO looking for a simple solution to sorting mySQL results alphanumerically where some fields may have special characters present. The solution:</p>
  
  <p><code>"SELECT *, REPLACE(title '\"', '') AS indexTitle ORDER BY indexTitle ASC";</code></p>
  
  <p>In this case I'm searching for strings that begin with a double quote, escaped.</p>
  
  <p>This probably wouldn't be a great solution where the types of special characters are not known, but for a simple sort it works nicely.</p>
  
  <p>Hopefully this helps someone.</p>