selecting second last row

[ross]

I have a table of publications. 

-- Table structure for news
-- ----------------------------
CREATE TABLE `news` (
  `id` int(100) NOT NULL auto_increment,
  `content` longblob,
  `title` varchar(100) default NULL,
  `date` date default NULL,
  `display` varchar(10) default 'no',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 

the column display = 'yes'; if the article is to be dispalyed on the homepage. 
I only have  2 yes columns equal to yes at any one time.


SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1

Think this would get the lastest article that is to be displayed but how do I 
get the second one.


R.