you could do select article_num from $table order by article_num desc LIMIT 75
> -----Original Message----- > From: Mark [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 06, 2003 8:40 AM > To: [EMAIL PROTECTED] > Subject: Last 75 entries from a table > > > Hello, > > Using MySQL 3.23.58, what I want is to select the last 75 > entries from a > table. Like so: > > "SELECT article_num FROM $table LIMIT 75" > > Except, of course, that this gives me the first 75, whereas I > need the last > 75. It sounds trivial; and it probably is, but I could not find it. > "article_num", by the way, is not necessarily sequentially > numbered, so > doing something from X-75 to X, will not work. > > Thanks, > > - Mark > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]