[Solved] Select from one table different values and limit them

by

[ad_1]

Since you want to get 80 rows for both text and NO text, you can use UNION ALL. You can also order your data as per your requirement:

(SELECT first_column, last_column
FROM MyTable
WHERE last_column = 'text'
ORDER BY first_column
LIMIT 80)
UNION ALL
(SELECT first_column, last_column
FROM MyTable
WHERE last_column = 'NO text'
ORDER BY first_column
LIMIT 80);

See this SQLFiddle

0

[ad_2]

solved Select from one table different values and limit them