Question

数据库查询某一字段值的id排序，用在查询另一个字段的值上

我用下面的命令取得了字段key里views值的降序排列，如图
SELECT id,key,value FROM 'my' WHERE key = 'views' order by value DESC LIMIT 0 , 30

现在我想用上面id的排序，取得字段key里的logo值，下图是直接查询的结果

注：编程语言php





Answer 1

SELECT id,key,value FROM 'my' WHERE key = 'views' order by value DESC LIMIT 0 , 30得到一组数组，然后遍历这个数组，得到数组的$arr[id]，然后根据这个$arr[id]去查字段key里的logo值，这个就不用我多写了吧，你应该会的，

Answer 2

假设xxx 是你的 第二个表：

SELECT t2.id,t2.key,t2.value,t1.value FROM 'my' t1,xxx t2 WHERE t1.key = 'views'
and t2.key = 'logo' and t1.id = t2.id
order by t1.value DESC LIMIT 0 , 30

Answer 3

SELECT id,key,value FROM 'my'
where kdy='logo' and id in( select id from 'my'
WHERE key = 'views' )order by id DESC