Hi all, sorry, I know the title is ambiguous, but I wasn't sure exactly how to explain it. Anyway, Say I have the following code: [code]'SELECT * FROM `table` WHERE `list_number` IN (1,3,5)[/code] Now, let's say that there are 20 rows for each matching `list_number` criteria (ie, There are 20 rows where `list_number` = 1, 20 rows where `list_number` = 3, and 20 rows where `list_number` = 5). What I would like to know is, how would I tell the MySQL query to get only 10 (in order or random, doesn't matter) rows for each `list_number`? I thought that LIMIT only worked for the entire query, not per where condition. Any help is appreciated! Thank you!