I need a refresher here. Let's say I want to select from a database where the user='blah' and subscribe='1' but there will be multiple entries for that user. This is for the boards I'm working on, if you need a better picture of what I'm doing.

So can I do:

Code:
SELECT UNIQUE user, subscribe WHERE user='blah' AND subscribe='1'
Or:

Code:
SELECT UNIQUE user WHERE user='blah' AND subscribe='1'
Or...?