使用IN()选择查询，不进行任何排序 [英] Select query using IN() and without any sorting

问题描述

我的查询

select * from product where productId in(25,36,40,1,50);

结果如下

`productId   ProductName  Qty Price`
-------------------------------------
`1          | namesome  | 5 | 25.00`
`25         | namesome  | 5 | 35.00`
`36         | namesome  | 5 | 35.00`
`40         | namesome  | 5 | 35.00`
`50         | namesome  | 5 | 35.00`

我没有使用任何order by子句，但是它由productId，
自动应用 我需要没有任何结果的结果，如下所示

I did not use any order by clause, But its automatically applied order by productId,
I need result with out any sort, as follows

`productId   ProductName  Qty Price`
-------------------------------------
`25        | namesome  | 5 | 25.00`
`36        | namesome  | 5 | 35.00`
`40        | namesome  | 5 | 35.00`
`1         | namesome  | 5 | 35.00`
`50        | namesome  | 5 | 35.00`

我该如何实现?
数据库引擎:MyIsam，整理:utf8_general_ci，productId

How can I achieve this?
Database Engine: MyIsam, Collation: utf8_general_ci, PrimaryKey on productId

推荐答案

select * 
from product 
where productId in(25,36,40,1,50) 
order by find_in_set(productId, '25,36,40,1,50');

这篇关于使用IN()选择查询，不进行任何排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！