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.

can someone point me to a portal that will allow me to access it ?

bill

1. Ask your ISP to carry it. I've found most are quite amiable to adding groups at user's requests.

2. Google Groups (if you really must).

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