遇到个数据库查询的问题，发来大家讨论下 :)

[昆泽]

表如下(name:relation)
======================
uid pid
1 test1
1 test2
1 test3
2 test1
...

现在想查询出 pid有test1和test2的所有的uid
大家有什么好的解决方案么？

[黄袍披身]

like 也行吧，不过好像非常的缓慢...

[昆泽]

我晕。。。是在不好意思，给错分了。。。30该给2楼的。。。

[happypiggy2010]

select count(uid) as c, uid from relation where pid in ('test1', 'test2')
group by uid
having count(uid)=2

[一起混吧]

select uid from relation where pid in ('test1','test2');

[回忆那么久]

二楼+1