Problem with MySQL query
Posted
by Psyche
on Stack Overflow
See other posts from Stack Overflow
or by Psyche
Published on 2010-05-13T17:56:26Z
Indexed on
2010/05/13
18:04 UTC
Read the original article
Hit count: 155
This time my setup looks like this: one table with galleries names (gallery_id, gallery_name) and another table with galleries photos (photo_id, photo_gallery_id, photo_name).
What I need is to get all the galleries with one random picture for each gallery.
Is it possible to do this with a single query?
© Stack Overflow or respective owner