From: Martijn Tonies
Date: August 14 2004 8:35am
Subject: Re: MYSQL RECORDS AND ALPHABETICAL ORDER
List-Archive: http://lists.mysql.com/mysql/170970
Message-Id: <002201c481d9$97acb120$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com