如何限制每行1等于相同的值

Question

to put it simple, I'm using this SQL:

dbquery("SELECT * FROM lottery WHERE num = '1111' ");

I basically want to select all the rows from the table, where the number equals 1111, but the users will be able to insert as many lottery tickets as they want, which can even be the same number, but I only want to return 1 per user.

LIMIT 1 WHERE username = 'Liam'

As a rough example, would this be possible? I'm not aware of any other methods that will work, from my knowledge.

Answer 1

You can simply use

select distinct userid, username
from lottery
where num = '1111';

in order to get each user just once.