From: Martijn Tonies Date: August 14 2004 9:12pm Subject: Re: MYSQL RECORDS AND ALPHABETICAL ORDER List-Archive: http://lists.mysql.com/mysql/170979 Message-Id: <00b501c48243$63ec3260$0a02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 take a good look here: http://www.w3schools.com/sql/default.asp With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com