PROS! EASY EASY EASY question to answer!

[brianb]

hell pros,

I am braindead at the moment and can't remeber how to do this.

In my MYSQL call, I'd like to call everything with a value of 1 and 4 under my category variable.

How the heck do I do this again????

WHERE category=1 AND 4

??????

Please help!

[whaites]

WHERE cat IN (1,4)

[brianb]

There it is! Thanks!

[juschillinnow]

or where category = 1 and where category = 4;

you may have to take out the second where.

[whaites]

oops, I gave you 1 OR 4, 1 and 4 is
WHERE cat=1 AND cat=4

[brianb]

Hey guys,

Sorry to tell ya, but out of all the solutions you guys are offering, the only thing that works is

WHERE cat IN (0,4)

BUT, you said this was OR not AND?

Help!

[Weedpacket]

Of course, you wouldn't get many matches if you want records where category=1 AND category=4, would you... how often will category be equal to 1 and 4 at the same time?

[brianb]

Ok. So OR is the solution huh?