How to sort objects so that some of them (by condition) are always at the end?

Question

MySQL

There are goods. Products have prices. Products can be sorted according to different conditions. Output page by page.
How to make it so that those goods whose price is equal to zero are always at the end?
For some time, no working solutions came to mind, except how to collect an array and display the array page by page.
But it seems that it should be possible to do this at the sampling level as well.

Answer 1

Option 1

SELECT .... WHERE price > 0 AND ... ORDER BY ...
UNION
SELECT .... WHERE price = 0 AND ... ORDER BY ...

Option 2
Option 3
Similar to option 2, but store has_price explicitly in the database
PS I think that the 3rd one is the most correct

Answer 2

SELECT * FROM goods .... ORDER BY <ваша выборка>, price DESC

Answer 3

Add a field indicating the presence of a price, because != 0 will be very bad, the index does not work here. Take a solution from DmitriyEntelis and add a check for this field in the 1st option in the 1st request.