I want to make a one query, using 2 columns.. First column - points, i'll order by it. Second has only 2 values - '1' or '2'.
and i want to select 200 values, 100 of them must have '1'-value, and others 100 have '2'. Ordering by points, no matter they have value of 2nd column '1' or '2' i can make 3 simple queries, WHERE secondcol = 1 LIMIT 100, then secondcol = 2 LIMIT 100 and last without second column, just order by points is there a way to make it in one query? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "mysql" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mysql -~----------~----~----~----~------~----~------~--~---
