避免选择复制的MySQL行

Question

与

SELECT `playerid` FROM `lb-world` WHERE replaced=50 AND type=0 >= 0.01 

我选择行，但在我的表我有

playerid | replaced | type | date 
12  | 50  | 0 | 2010 
12  | 50  | 0 | 2011 
12  | 50  | 0 | 2012 

如何选择它只是一次？

Answer 1

如果你只是想playerid，您可以使用DISTINCT

SELECT DISTINCT `playerid` FROM `lb-world` WHERE replaced=50 AND type=0 >= 0.01 

Answer 2

试试这个：

SELECT `playerid` FROM `lb-world` 
WHERE replaced=50 AND type=0 
GROUP BY playerid, replaced, type 

这应该是通用的。
无论如何，如果你确信你只是想playerid，使用此

SELECT DISTINCT playerid FROM lb-world 
WHERE replaced=50 AND type=0 

Answer 3

SELECT DISTINCT playerid.. 

为@迈克尔说