If you know the list of Ids, try select id, title from content where id in (100, 106, 109);
If you want the list to be random, then you can use the RAND() function. Quentin -----Original Message----- From: kalin mintchev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 August 2006 2:10 p.m. To: mysql@lists.mysql.com Subject: select random ids from list hi all... how can i do a query on a list of ids without doing individual queries for each one of them? something like: select id,title from content where id = 100,106,109; of course this doesn't work... is it possible somehow? thanks.... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]