> SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC LIMIT > 1; > COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date that > the record was inserted
This would only select one row (the most recent). I need a set of rows, one for _each_ type of food (one and only one for tomatoes, one and only one for potatoes and so on). Mateusz Uzdowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
