@H_404_1@我使用以下sql从MySQL数据库中选择记录：
@H_404_1@
SELECT * FROM cms_product WHERE id IN (3,22,1);
最佳答案
众多选择 –
@H_404_1@案件：
@H_404_1@首选,是ANSI-92,它可以移植到其他数据库.
@H_404_1@
> FIELD
> FIND_IN_SET
SELECT *
FROM cms_product
WHERE id IN (3,1)
ORDER BY CASE id
WHEN 3 THEN 1
WHEN 22 THEN 2
WHEN 1 THEN 3
END
SELECT *
FROM cms_product
WHERE id IN (3,1)
ORDER BY FIND_IN_SET(id,'3,1');
SELECT *
FROM cms_product
WHERE id IN (3,1)
ORDER BY FIELD(id,1);
> FIELD
> FIND_IN_SET