php - 我有一个 sql 查询，其中我在 IN 中使用了一个 id 列表，我希望我的结果按照我的列表排序

Question

我的查询是

SELECT *
FROM `wp_patient_bill`
WHERE `bill_code` !=''
AND `is_billed` = 'Y'
AND `charged` = 'N'
AND `id` IN (97,419,631,632,633,422,635,421,35,799,60,423)

我希望记录数组根据我的列表进行排序，即 ID

'97,419,631,632,633,422,635,421,35,799,60,423'

.我正在使用 PHP。请建议我优化方法。

Answer 1

这是另一种解决方案:

SELECT *
FROM `wp_patient_bill`
WHERE `bill_code` !=''
AND `is_billed` = 'Y'
AND `charged` = 'N'
AND `id` IN (97,419,631,632,633,422,635,421,35,799,60,423)
ORDER BY FIELD(`id`,97,419,631,632,633,422,635,421,35,799,60,423)

引用:SQL order by sequence of IN values in query