功能描述:现有表a ,有字段 rowguid,danwei_name,danwei_guid 等,现已知三个danwei_guid,分别记为 danwei_guid1,danwei_guid2,danwei_guid3,想要查出这三行数据,按照danwei_guid排序,由于danwei_guid 是无序的,所以不能直接用order by +字段 , 可以用如下sql语句解决
SELECT *
FROM a
WHERE danwei_guid IN (danwei_guid1, danwei_guid2, danwei_guid3)
ORDER BY (
CASE id
WHEN danwei_guid1 THEN 1
WHEN danwei_guid2 THEN 2
WHEN danwei_guid3 THEN 3
END
)