Can't I put an IF / CASE in the query to make it work ? [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]
> -----Original Message----- > From: Brett Error [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 19, 2001 8:01 PM > To: 'Jacob Friis Larsen'; Mysql maillist > Subject: RE: select 10 of each > > > 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