How do I disable auto ordering of SELECT statement in SQL query?

Question

I want to fetch data from database in the order of given ids - IN(9,5,2,10)

Problem:
The result is fetched in the ascending order
Also I don't want the results in descending order.

Example:
$query = "SELECT * FROM products WHERE id IN(9,5,2,10)

So first, data of starting parameter 9 should be fetched in the client computer then 5,2 then at last , id 10.

Help is highly appreciated!

Answer 1

Coding San what I mean by this is that from you above mentioned query can be repeated for each individual id.

Answer 2

You can select each one id once.
… where id=9
… where id=5
etc.

Answer 3

You can use CASE.
https://learnsql.com/blog/order-by-specific-value/

Answer 4

You can select specific portion of data (2,5,9,10) and then sort them using backend language like php.

Answer 5

Coding San if the ordering is not completely ad-hoc, but based on actual field values, then you can specify ordering even if you don't select the columns that you order by.
For example:
SELECT name
FROM people
WHERE id IN(2, 5, 9)
ORDER BY age

Answer 6

JaScript this is actually for a product CART(e-commerce). Can you clarify your answer in more detail?

Answer 7

Oboh Boniface Emesealu you can enter multiple conditions after WHERE clause and combine them with AND, OR and use parentheses as needed. The conditions can refer to different columns.

Answer 8

Thank you all for the replies. I will implement all your suggestions and get back to you