Hi, the basic thing is that you must never assume anything on what order you're getting your rows back if you're not using an order by.
This said I guess one way for you to do this is to add a row-number column, preferbly auto-increment, and then order by that column. /Johan Schimmel LCpl Robert B wrote:
I am having a problem with using a select statement to retrieve a result set in a particular order. If I do a select * from the table without an order by clause, I get the results in the order which they were entered into the table (which is how I want them). However, the table has multiple columns in it and I only want one column in the result set. When I do a select [column_name] from the table, because of MySQL's go-getter attitude, the results are sorted alphabetically for that one column. How can I get just the one column of data that I want returned in the order which it was entered into table?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]