[Solved] Select from one table different values and limit them
[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’ … Read more