mysql select help needed

[spires]

Hi.

 

I'm trying to select user from the database depending on the users access level.

However, I can only select one level at a time.

 

This is what I want to do:

SELECT * FROM csv_login WHERE login_level='2' && login_level='4'

 

But this will bring back nothing.

 

It will only let me do:

SELECT * FROM csv_login WHERE login_level='2'

OR

SELECT * FROM csv_login WHERE login_level='4'

 

But not both.

How do I get around this?

 

Thanks for your help.

[Mchl]

SELECT * FROM csv_login WHERE login_level='2' OR login_level='4'

[spires]

Of Course

Seems so obvious now.

 

Thanks for your help