select in order by , mysql排序

select in order by , mysql排序

If i select like this:

SELECT id FROM users WHERE id IN(3,4,8,1);

This by default will select users in this order

1,3,4,8,

I would like to select them in the same order that i put IN() values so:

3,4,8,1

Use ​​FIELD()​​ for that

SELECT id FROM users WHERE id IN(3,4,8,1)orderby field(id,3,4,8,1)

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。