gdev's recent timeline updates gdev's recent timeline updates |
gdevV2EX member #492946, joined on 2020-06-03 14:36:00 +08:00 |
gdev's recent replies
Jun 5, 2020 Replied to a topic by Renco › Java › 多个查询条件 有一个条件匹配就查出 排序按照条件匹配最多的顺序排 要怎么实现 |
SELECT * FROM 资料表 AS t1
LEFT JOIN(
SELECT id,IF(`品牌` = '品牌 A',1,0) c1,IF(`型号` = '型号 A',1,0) c2,IF(`名字` = '名字 A',1,0) c3,IF(`规格` = '规格 A',1,0) c4 FROM 资料表
) AS orderTable
ON t1.id = orderTable.id
ORDER BY (c1+c2+c3+c4) DESC
LEFT JOIN(
SELECT id,IF(`品牌` = '品牌 A',1,0) c1,IF(`型号` = '型号 A',1,0) c2,IF(`名字` = '名字 A',1,0) c3,IF(`规格` = '规格 A',1,0) c4 FROM 资料表
) AS orderTable
ON t1.id = orderTable.id
ORDER BY (c1+c2+c3+c4) DESC
Select Language