Date: 01/23/09 (PHP Community)    Keywords: php, mysql, sql

I'm pretty sure there's a term for my title ("Listing alphabetically omitting "the" or "a"") but I'm not sure what it is.

But that is essentially what I need...

I use MySQL to store entries with titles. In the PHP I can populate an alphabetical list, but I'd like to go a step up and try and omit the "the" and "a" etc. So something called: "A Pen" would appear under P.

How would I do this?

Am I correct in thinking this will require lots of brain power? :P

Thanks!

Source: http://community.livejournal.com/php/655446.html