How to get all fields from the database?

Question

MySQL

Let's say we have an articles table. It has fields id, name, description, category, etc.
How to get all the fields from the database, but so that the fields with category=1 and category=3 are first, and then all the rest?

Answer 1

SELECT * FROM articles ORDER BY FIELD(category, 3, 1) DESC;

Example