Query Sqlite Database by specific/custom ordering?
cursor, sql-order-by, sqlite
Solution
EDIT:
Tested, works:
SELECT * FROM books WHERE _id IN(4, 1, 5)
ORDER BY
CASE _id
WHEN '4' THEN 1
WHEN '1' THEN 2
WHEN '5' THEN 3
ELSE 4
END, _id;
Problem
Let's say I got a table, something like this: ID | TITLE 1 | AAA 2 | BBB 3 | CCC 4 | DDD 5 | EEE ... ... I want to perform a query, using IN opeator, while preserving the order of the IN Arguments ``` database.query("some_table", null, ID + " IN("+ idsStr+")", null, null, null, null); ``` For example, if the query is "select from some_table where id in (4,1,5) ...(order by???)", I want that the returned cursor to be sorted as 4,1,5 Is it possible? how?