Re: ordering mysql request by part of a key

bill wrote:
Jerry Stuckle wrote:

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.


been there, done that, no response to my request. (but it has only been 7 days, so far :-\


2. Google Groups (if you really must).


Only if the wonderful people on this ng can't help.


bill


The point is - this is not a mysql newsgroup. You should take your questions to the appropriate newsgroup. That's why comp.databases.mysql was created.

And I would suggest you ask your isp again. It might have gotten lost during the holidays.


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