Anyone know of an easy way to sort through a list of titles in a DB, excluding the word "the" from the sort? Say, a list of book titles or poems?
Thanks.
SELECT book FROM books_table WHERE title <B>NOT IN ('the')</B>
It's case insensitive, at least in MySQL. If anyone knows a way to make a case-sensitive search this way, i'd like to know about it.
fLIPIS
select * from poems order by replace(title,'the ','')
Actually, I want the SELECT to bring in titles that include the word "the," but I want those titles sorted appropriately--i.e., not under "T" for "the," but under, say, "R" for "The Raven."
Does that make any sense?
Excellent! Thanks a lot!
