Re: ordering mysql request by part of a key
- From: bill <nobody@xxxxxxxxxxx>
- Date: Sat, 30 Dec 2006 16:27:59 -0500
strawberry wrote:
bill wrote:Jerry Stuckle wrote:bill wrote:my isp does not supply this ng.I have a database of kennels. One page lists the kennelscomp.databases.mysql would be a much better place to ask this question.
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
My earlier reply seems to have got lost:
SELECT kennel FROM kennels ORDER BY REPLACE(kennel,'the ','');
well, that is easy enough.
Many thanks.
bill
.
- References:
- ordering mysql request by part of a key
- From: bill
- Re: ordering mysql request by part of a key
- From: Jerry Stuckle
- Re: ordering mysql request by part of a key
- From: bill
- Re: ordering mysql request by part of a key
- From: strawberry
- ordering mysql request by part of a key
- Prev by Date: Re: phpinfo() - strange results...
- Next by Date: Re: ordering mysql request by part of a key
- Previous by thread: Re: ordering mysql request by part of a key
- Next by thread: Re: ordering mysql request by part of a key
- Index(es):
Relevant Pages
|
