Strange MySQL behavior: sorting of results depends on select?

Question

MySQL

MySQL 5.5 is used.
When requested:

SELECT id, name FROM products WHERE some_id = 48 AND another_id = 1 ORDER BY product_sort desc

there is only one sorting of results, and when querying:

SELECT * FROM products WHERE some_id = 48 AND another_id = 1 ORDER BY product_sort desc

- another. Why is this so, and how can I make sure that when select * the sorting of the results is the same as in the first query?

Answer 1

these are two different queries, and product_sort is most likely not very unique. so the records with the same product_sort are displayed in random order. For example, in the first case, the index was read, and in the second, the clustered index.