我怎么能过滤重复？ [关闭]

Question

INFORMATION:

TABLE = giveaway

FORM 1 = id

FORM 2 = username

FORM 3 = userid

FORM 4 = wish

END OF INFORMATION

I am trying to make it filter through duplicate usernames and userids

NOTE: people enter the userid and the username (it is for a giveaway)

can anyone post me some code to do that?

Answer 1

Try this one:

SELECT  `username`,`userid` FROM `giveaway` group by `username` HAVING COUNT(`username`) > 1 UNION SELECT `username`,`userid` FROM `giveaway` group by `userid` HAVING COUNT(`userid`) > 1