PrestoDB - Order results by the order specified in the WHERE IN clause

Question

I saw in other posts that we can do this with the FIELD() function in MySQL. I am wondering if there is an equivalent of FIELD() in presto. Thank you very much.

Answer 1

Don't use in. I would recommend join with values:

select t.*
from t join
     (values (1, 'val1'), (2, 'val2'), (3, 'val3')) v(ord, val)
     on t.col = v.val
order by v.ord;