You may be able to sort using a regex expression.
David
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 1:39 AM
To: 'abdul - ÚÈÏ ÇáÑÍãä' <[EMAIL PROTECTED]; [EMAIL PROTECTED]>
Subject: Re: ignoring in ORDER
Hi Abdul,
C
Hi Abdul,
Can Mysql ignore alphabet , like 'the' when
ORDERING a name.
A sample :
I have a table (first_name) :
- The test.
- Falcon
- The Armageddon
- Battle
When ordering it will be :
Battle
Falcon
The Armageddon
The test.
Can it be like this :
The Armageddon
Battle
Falcon
The test.
About 3 months ago, there was a long discussion thread about this very
topic.
Final answer: "the","a","an" must be handled in the language
(perl/php/etc...). Or, you must change data in your fields so that these
words are NOT the first in the field.
-Original Message-
From: abdul - "ÚÈ
