double WHERE

[d2ns]

hi,

is there a valid command for selecting a row depending on 2 instead of 1 argument?

this is a valid command.
SELECT * from 'data' WHERE date='today';

but is there a way to do this... ???
fi; SELECT * from 'data' WHERE date='today' & week='thisweek';

probably a real simple awnser to a real simple question.

thanks...

[xblue]

as many as you want 😉

use && or AND (or || or OR) - I think AND and OR are more common.

btw, a search for & on mysql.com would have brought you there:
http://www.mysql.com/doc/en/Logical_Operators.html
quite easy to find.