Multiple "WHERE's" 3

[annasue]

I need to select two projects from my database. I have the statement:

Select * from projects WHERE `project_name` = "A New Project" && WHERE `project_name` = "John's Project"

It doesn't like that; what is the syntax for selecting multiple entries? I tried it without the second "WHERE" and it didn't like that any better.

Thanks in advance.

 

[sleipnir214]

A query can only have one where clause.

But what you're trying to do is pick those records which fit any of multiple criteria.

Select * from projects WHERE `project_name` = "A New Project" or `project_name` = "John's Project"





Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Chacalinc]

To me && is AND, so in addition to sleipnir's post:

SELECT * FROM projects WHERE `project_name` = "A New Project" AND `project_name` = "John's Project"

Cheers.

 

[Chacalinc]

oops... sorry, I didn't see the fields... they are the same one.. the it should be OR and not AND.

Sorry again.

 

[annasue]

Thank you so much. The OR worked like a charm!

 

[KarveR]

you could also use IN:
Select * from projects WHERE `project_name` IN ("A New Project","John's Project")

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.