selecting only the last 3 rows when ordering by date

[turbo-newbie]

SELECT title, news_body, date FROM bg WHERE ????????
ORDER BY date

how to select the last 3 rows?

[kender]

SELECT title, news_body, date FROM bg ORDER BY date DESC LIMIT 0 , 3

SELECT = what you are getting
FROM = where date comes from
ORDER BY = what to sort by
DESC = descending order (ASC would be ascending)
LIMIT 0,3 = return items 0 - 3 (3 items) in that order can also LIMIT 3,6 (return items 3 - 6)

[turbo-newbie]

thank you

[kender]

glad i could help, please mark thread resolved (bottom center of this page - just below my post)