Random Rows

[L]

Okay,

Let's say I have a table containing photos and they are also
categorized according to the event that the photos were taken from.
How can I select a recordset of one random photo from each category?