RE: multiple where's

2002-06-05 Thread Jay Blanchard
[snip] I am new to MySQL and SQL in general. I was wondering how to narrow down a search. I wanted to do something like select * from table where x, y, z; but this doesn't work. Can someone help me? [/snip] select * from table where x and y and z HTH! Jay It's hip to snip!

Re: multiple where's

2002-06-05 Thread Victoria Reznichenko
Chris, Wednesday, June 05, 2002, 6:51:16 PM, you wrote: CH I am new to MySQL and SQL in general. CH I was wondering how to narrow down a CH search. I wanted to do something CH like CH select * from table where x, y, z; You can use AND and OR in WHERE clause, f.e. SELECT * FROM table WHERE