by the way, the structure of the table is as follows: id (auto-increment) name (varchar: 50) type (enum: 'A','L','P')
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, February 23, 2006 1:13 PM To: CF-Talk Subject: quick mysql 4.0.17 query question... I've got a table with an ENUM column that has 3 possible options. I want to return 4 random entries for each option. I know how to get N random records, but this requires that I get 4 of each type. Is it possible to do this in one query and if so how might I do that? <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54