Two conditions for one field in MySQL WHERE

Question

Hi,

Is there a way for me to have two conditions on one field in MySQL Where?... I have a field called type and I want to do this:

WHERE `type` != 'name' AND `type` != 'photo'

I'm hoping for a better way to do that, so I could compare type to two possible options?

Thanks!

Answer 1

if you mean AND - you probably do, because OR will always match :) -

WHERE `type` != 'name' AND `type` != 'photo'

then

WHERE `type` NOT IN ('name', 'photo')

should cut it.

Answer 2

You can use

where type not in ('name','photo')