Posted by bill on 12/30/06 01:23

I have a database of kennels. One page lists the kennels
alphabetically by kennel name.
I have a field for kennel name and an index with kennel name as
the only field.

Some of the kennels have the word "The" as the first word in the
name and they do not want to be listed alphabetically by "The..."

Is there a way that I can request that mysql ignore "The" in a
kennel name when ordering it or must I create a new field for the
ordering and remove the "The" from the kennel name for that field ?

bill

[Back to original message]