You'll have to issue two separate queries: "select * from table where lang=1 limit 10" and "select * from table where lang=2 limit 10"
-----Original Message----- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:46 AM To: Mysql maillist Subject: select 10 of each How do I select 10 rows with lang = 1 and 10 rows with lang = 2 from a MySQL database ? Please also reply to my E-Mail address. :) Jacob --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
