| Is this possible in Mysql
|
Elric99
msg:4188174 | 9:14 am on Aug 17, 2010 (gmt 0) |
If I have a table with 100 products in it, half are from Brand A, half are from Brand B. How do I say:
SELECT * FROM table_name
LIMIT 20
BUT ... show 10 products from Brand A and 10 products from Brand B
Maybe it's early but I can't quite get my head around how to write this query.
Thanks!
|
brotherhood of LAN
msg:4188216 | 11:51 am on Aug 17, 2010 (gmt 0) |
You can use the UNION operator, so something like this should be good.
SELECT * FROM table WHERE product = 'a' LIMIT 10
UNION
SELECT * FROM table WHERE product = 'b' LIMIT 10
|
|
|
