Re: ordering mysql request by part of a key


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

.

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 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
    ... 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)