SQL Order By, excluding 'the'

[eluser]bradya[/eluser]
Hi Guys,

I know this isn't a CI specific question, but though you might have some ideas on it. I am fetching a list of bands from a mysql table, and ordering by band name. Problem being that any band beginning with 'the' eg. 'The Sleepy Jackson' is automatically put as a 'T' rather than 'S'.

So, does anyone know of a way to order sql results, but to exclude words like 'the', kind of like stopwords in a full-text search I guess...