<div>
Is there an easier way to do this query?<br />
The IN list will be dynamic.<br />
<br />

</div>


Is there an easier way to do this query?
The IN list will be dynamic.



<div>
not that I know of.<br />
but if the &quot;IN&quot; list will be dynamic, so can be your order by?
</div>


not that I know of.
but if the "IN" list will be dynamic, so can be your order by?

<div>
Try this:<br />

<pre><code id="code-20-34927178-1">SELECT * FROM acct WHERE acct_num IN (200,100,150) ORDER BY FIELD(acct_num,200,100,150);</code></pre>
</div>


Try this:


SELECT * FROM acct WHERE acct_num IN (200,100,150) ORDER BY FIELD(acct_num,200,100,150);

<div>
actually, that is a good one!
</div>


<div>
<div class="content wysiwyg-content">
I want to ORDER my sql query based on the IN clause<br />
<br />
select * from acct where acct_num in (200,100,150) order by (200,100,150)<br />
<br />
My result is ordered by <br />
100,150,200<br />
I assume because acct_num is an index.<br />
<br />
I want my resulting order to be <br />
200,100,150<br />

</div>
</div>


I want to ORDER my sql query based on the IN clause

select * from acct where acct_num in (200,100,150) order by (200,100,150)

My result is ordered by 
100,150,200
I assume because acct_num is an index.

I want my resulting order to be 
200,100,150


mysql ORDER BY based on IN clause

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.