hi there.. no solution from me, but I'm also interested in this type of query (although I only want 1 for each "lang") I also wants it in 1 query, not multiple (it would be to many queries) so any answer to this one please please reply to me to :-) although I do read here also...
/Christian ----- Original Message ----- From: "Jacob Friis Larsen" <[EMAIL PROTECTED]> To: "Brett Error" <[EMAIL PROTECTED]>; "Mysql maillist" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 8:11 PM Subject: RE: select 10 of each > 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 > > --------------------------------------------------------------------- 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
