Alphabetising removing "The " from the beginning of results

[almightyegg]

I am trying to generate an alphabetical list of albums as such

The Bachelor

Best of Supertramp

Dark side of the moon

etc...

 

As you can see, The Bachelor is first because I want it to remove the "The" so it alphabetises it by "Bachelor"

 

So my question is how would I alphabetise it in a ORDER BY clause within a mysql_query()

At I guess some sort of explode or implode but I don't know how I'd check if it has "The" at the beginning

 

Thanks for help

[PFMaBiSmAd]

http://www.arraystudio.com/as-workshop/how-to-sort-mysql-results-ignoring-definite-and-indefinite-articles-the-a-an.html