how can I skip the last value of a field when showing results?

Hello,

I need to show the second latest value of a table on the results, how can I skip the last value with mysql?

i know that the last value will come up with something like this:

SELECT * FROM noticias WHERE categoria = 2 ORDER BY id_noticia DESC LIMIT 1";  

PHP:

but how can I show the second one?


thanks in advance!

 

SELECT * FROM noticias WHERE categoria = 2 ORDER BY id_noticia DESC LIMIT 1,1";