This post is to document how to perform a query in PHP using MySQL for specific known Ids.

For example, I know the ids to be query therefore, the query may look like this:

$sql = "SELECT * FROM table WHERE id IN(1,4,3,2) ";

If you performed the above query, you might get an array like this [1,2,3,4]

However, I need the order of the query to be exactly as all the ids inside the IN() statement. The answer is the following:

ORDER BY FIELD(id, 1,4,3,2)

Now we can change our query to look like this:

$sql = "SELECT * FROM table WHERE id IN(1,2,3,4) ORDER BY FIELD(id, 1,4,3,2)";

your array query will look like this: [1,4,3,2] which is exactly how I wante it.

Hope that helps.