title: How to sort MYSQL query to display alphabetically, with numbers last, and not including the word "The" in sort
body: <p>Basically I have a PHP MYSQL query which returns 16 items. 15 of them start with letters A-Z, and one starts with a number (the name of a product is "3d Star Gazer"). In a regular query, sorting alphabetically displays this one item that starts numerically first. I want the list to be sorted alphabetically, with the 3d Star Gazer displayed last.</p>
  
  <p>Is this possible?</p>
  
  <pre><code>SELECT t1.id, t2.name, t2.manufacturer
  FROM db.t1
    LEFT JOIN db.t2 ON t1.id = t2.id
  WHERE year = '2011'
  ORDER BY t2.name ASC
  </code></pre>
  
  <p>I saw this link: <a href="https://stackoverflow.com/questions/5861852/sort-mysql-results-alphabetically-but-with-numbers-last">Sort MySQL results alphabetically, but with numbers last</a> but the solution wasn't working for me...</p>
  
  <p>As a secondary question, is it possible to not include the word "The" in the sort? For example, a game is called "The Guessing Game," I want it to appear sorted as "G", not as "T".</p>