wondering whether someone can set me straight on whether it's possible to
request a set of records from a single table with multiple conditions.
for instance, a "story" table, containing id, title, text, section and
published_date. what i would like is to retrieve is the 5 most recently
published stories from each section (currently there are nine sections).
so, do i have to do this in nine separate queries or can i do something like:
SELECT id, title, text, sectioned, published_date
WHERE (section = 'events' order by published_date desc limit 5) and
(section = 'features' order by published_date desc limit 5)