Can you use OR in the where clause?

[dudejma]

I was just wondering if you could use OR in the where clause. I've never done it before.

 

For example:

$sql = "SELECT * FROM users WHERE status='1' OR status='2' OR status='3' OR status='4'"

 

What it is, I have users where their status is 0 meaning that they're not suspended, but they're just not activated.

 

Thanks guys!

[Pikachu2000]

You could have tried it and had your answer in the time it took you to post the thread and wait for a response, but yes you can do that.

[AyKay47]

You could have tried it and had your answer in the time it took you to post the thread and wait for a response, but yes you can do that.

such a gentlemen Pikachu..

but you do have a point

[kickstart]

Hi

 

You can, but the confusion comes when you mix OR and AND, and come across operator precedence.

 

All the best

 

Keith

[dudejma]

I was going to try it but then I'd have to make the database and go through all that which I'm not quite to yet. I'm just planning out things before I completely smart. But well said Pikachu(:

[silkfire]

Just a tip matey: in this case you don't need to use  OR because you're matching against the SAME column. Plus, it's numbers which makes things even easier:

 

$sql = 'SELECT * FROM users WHERE status BETWEEN 1 AND 4';