Long sql statment

[ashz]

Hello,

Is there any better way to write the following statement: select * from car where model=’1’ and model=’x’ and model=’23’ model=’zx’.

Thanks.

 

[sleipnir214]

You're missing one "and" or "or" near the end of the statement.

Also, that query will never return any rows. The column "model" can't be all four of those values at the same time.

Did you mean:

select * from car where model=’1’ or model=’x’ or model=’23’ or model=’zx’ Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[mweinstock]

If you did mean "or", you can use the IN statement:

select * from car where model IN (’1’,’x’,’23’,’zx’)
--
How can you be in two places at once when you're not anywhere at all?

 

[sleipnir214]

ashz:

Either way you do it, we cannot give any more specific advice without knowing your database schema and what it is you are trying to do. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!