As tu essayé :

SELECT * FROM machin
WHERE col1 = x
AND col2 = x
AND col3 = x ;

:)