RE: ignoring in ORDER

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

Re: ignoring in ORDER

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.

RE: ignoring in ORDER

ginal Message- From: abdul - "ÚÈÏ" "ÇáÑÍãä [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 09, 2002 2:01 PM To: [EMAIL PROTECTED] Subject: ignoring in ORDER Hi, Can Mysql ignore alphabet , like 'the' when ORDERING a name. A sample : I have a table (first_name

ignoring in ORDER

Hi, 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

ignoring in ORDER

Hi, 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