Multiple AND conditions MySQL

Question

How can I have multiple AND conditions in a clause? Like SELECT * FROM database WHERE x=x,y=y AND z=z I tried that, and it didn't work. Thanks.

Answer 1

SELECT * FROM database WHERE `x`=x AND `y`=y AND `z`=z

Answer 2

SELECT * FROM table WHERE x=x AND y=y AND z=z