From: Ralf Hüsing
Date: October 25 2007 12:55pm
Subject: Re: Select question
List-Archive: http://lists.mysql.com/mysql/209687
Message-Id: <47209242.7030001@stormbind.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Matthew Stuart schrieb:

 > I've got this statement to select the last two entries in my db:
 >
 > SELECT top 2 *
 > FROM Content
 > ORDER BY ContentID desc
 >
 > and it works fine because it selects the last two items entered into 
the db. However, I only want to be able to select item 2 rather than 
both 1 and 2. How do I do that?

Hi Mat,

"TOP 2" is not MySQL?

However, MySQL knows LIMIT [1] which is more powerful, try:

   SELECT *
   FROM Content
   ORDER BY ContentID DESC
   LIMIT 1,1

regards
   -Ralf

[1]: http://dev.mysql.com/doc/refman/5.0/en/select.html