Posted by strawberry on 12/30/06 15:44

bill wrote:
> Jerry Stuckle wrote:
> > bill wrote:
> >> 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
> >
> > comp.databases.mysql would be a much better place to ask this question.
> >
> my isp does not supply this ng.

My earlier reply seems to have got lost:

SELECT kennel FROM kennels ORDER BY REPLACE(kennel,'the','');
>
> can someone point me to a portal that will allow me to access it ?
>
> bill

[Back to original message]