Alphabetize without 'The'

[MikeDXUNL]

right now my query is:

 

mysql_query("SELECT * FROM videogames WHERE type='$type' AND gamename LIKE '$letter%' ORDER BY gamename ASC") or die(mysql_error());

 

 

is there a way I can exclude 'The' at the beginning of a title. and put it at the end?

 

I.E {

 

Grand Theft Auto IV

Halo 3

Incredible Hulk, The

 

}

 

then when the user clicks on the "I" link, Incredible Hulk will show up there instead of in the "T" link

[BillyBoB]

You could just add them to the database like that. And if wanted change with php on display.

[xtopolis]

You might possibly be able to add a mysql clause to support that:

 

... LIKE '$letter' OR LIKE '%the%$letter'...

Do it on your phpMyAdmin if you have it, I didn't test that statement, but it should work.

[xtopolis]

Err, mine should only have one % sign,  : OR LIKE 'the%$letter'

Just to be safe.  And it worked in my small test :3