title: MySQL sort by name
body: <p>Is ir possible to sort a column alphabetically but ignoring certain words like e.g 'The'</p>
  
  <p>e.g.</p>
  
  <p>A normal query would return</p>
  
  <pre><code>string 1
  string 3
  string 4
  the string 2
  </code></pre>
  
  <p>I would like to return </p>
  
  <pre><code>string 1
  the string 2
  string 3
  string 4
  </code></pre>
  
  <p>Is this possible?</p>
  
  <p><strong>EDIT</strong>
  Please note I am looking to replace multiple words like The, A, etc... Can this be done?</p>