I want to use a SELECT query with an IN clause, as well as Order by value same as IN clause
Query:
<code>select *
from table
where column_xyz IN ('124','225','111') // Here values must be in single quotes in query
Output needs to be fetched : 124,225,111
</code>
<code>select *
from table
where column_xyz IN ('124','225','111') // Here values must be in single quotes in query
Output needs to be fetched : 124,225,111
</code>
select *
from table
where column_xyz IN ('124','225','111') // Here values must be in single quotes in query
Output needs to be fetched : 124,225,111
Tried query :
<code> select *
from table
where column_xyz IN ('124','225','111') order by field(column_xyz,'124','225','111')
</code>
<code> select *
from table
where column_xyz IN ('124','225','111') order by field(column_xyz,'124','225','111')
</code>
select *
from table
where column_xyz IN ('124','225','111') order by field(column_xyz,'124','225','111')
In mysql we have option called ‘FIELD’ but for postgres I am unable to work with ‘FIELD’ i.e it didn’t work