ordering mysql request by part of a key

From: bill <nobody@xxxxxxxxxxx>
Date: Fri, 29 Dec 2006 20:23:54 -0500

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
.

Follow-Ups:
- Re: ordering mysql request by part of a key
  - From: Jerry Stuckle

Prev by Date: I need some ideas on XML parsing.....
Next by Date: Re: How to build a web application the right way
Previous by thread: I need some ideas on XML parsing.....
Next by thread: Re: ordering mysql request by part of a key
Index(es):
- Date
- Thread

Relevant Pages

Re: ordering mysql request by part of a key
... bill wrote: ... 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..." ... JDS Computer Training Corp. ...
(comp.lang.php)
Re: ordering mysql request by part of a key
... Jerry Stuckle wrote: ... 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..." ...
(comp.lang.php)
Re: ordering mysql request by part of a key
... strawberry wrote: ... I have a field for kennel name and an index with kennel name as the ... Some of the kennels have the word "The" as the first word in the name ...
(comp.lang.php)
Re: ordering mysql request by part of a key
... bill wrote: ... I have a field for kennel name and an index with kennel name as the ... Some of the kennels have the word "The" as the first word in the name ... SELECT kennel FROM kennels ORDER BY REPLACE; ...
(comp.lang.php)
Re: ordering mysql request by part of a key
... bill wrote: ... I have a field for kennel name and an index with kennel name as the ... Some of the kennels have the word "The" as the first word in the name ... SELECT kennel FROM kennels ORDER BY REPLACE; ...
(comp.lang.php)