Question

我从<代码>IN获取数据。以这种形式提出的问题

SELECT * FROM wp_devices WHERE QID=’1′ and DId IN(36,71,37,39,38)

But they are displaying in this format DId IN(36,37,38,39,71) instead of DId IN(36,71,37,39,38).

我应该做些什么?

Answer 1

You should add order by clause to your query. Because your order is a little bizarre you must to write case workflow code:

SELECT * 
FROM wp_devices 
WHERE 
   QID= 1  and 
   DId IN (36,71,37,39,38) 
ORDER BY
   case DId
     when 36 then 1
     when 71 then 2
     when 37 then 3
     when 39 then 4
     when 38 then 5
   end

I suppose that you work with mysql because you have another question that is tagged like this. Then you can simplify previous query using field function:

SELECT * 
FROM wp_devices 
WHERE 
   QID= 1  and 
   DId IN (36,71,37,39,38) 
ORDER BY
   field( DId, 36,71,37,39,38 )

发出通知说,现场用示着一种暗含的种类。

Answer 2

在数据被丢弃之前实际操纵吗? 每一行都将有<代码>。 DId, as one of the Value in the row.

如果您需要具体命令,则按该顺序排出如下: > > 排出,并收回结果。

友情链接