Hi,
I have mysql table which retains names,Data is written to mysql table
using
php query, however when I check the records, I amn't able to do the same
in
alphabetical order.
How do I make mysql to retain records in alphabetical order.
With an ORDER BY clause perhaps?
With regards,
SELECT * FROM mytable ORDER BY alphabetical_field
hth
Peter
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 August 2004 08:57
To: [EMAIL PROTECTED]
Subject: MYSQL RECORDS AND ALPHABETICAL ORDER
Dear Friends,
I have mysql table which retains
A defining feature of a relational database is that its data storage is
entirely independent of the physical order of rows. To specify row order in
a query, use an ORDER BY clause.
PB
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 14,
Dear friends,
In this query what precisely needs to be added at alphabetical_field
following ORDER BY
SELECT * FROM mytable ORDER BY alphabetical_field
so that I get output in alphabetical order.
guidance, please.
--
My
PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MYSQL RECORDS AND ALPHABETICAL ORDER
Dear friends,
In this query what precisely needs to be added at alphabetical_field
following ORDER BY
SELECT * FROM mytable ORDER BY alphabetical_field
so that I get output in alphabetical order.
guidance
Hi,
Dear friends,
In this query what precisely needs to be added at alphabetical_field
following ORDER BY
SELECT * FROM mytable ORDER BY alphabetical_field
so that I get output in alphabetical order.
guidance, please.
I highly suggest reading a book (any book) on SQL (not MySQL)
or