Re: ordering mysql request by part of a key

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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

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. ... 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? ... Ask your ISP to carry it. ...
    (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 only field. ... Ask your ISP to carry it. ... Google Groups. ...
    (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)
  • Re: ordering mysql request by part of a key
    ... I have a field for kennel name and an index with kennel name as the only field. ... 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? ... Ask your ISP to carry it. ...
    (comp.lang.php)