14.3. Where

This is the easiest thing to understand — it’s the same animal in both languages. It filters out result sets/subgraphs. Not all predicates have an equivalent in the other language, but the concept is the same.

SQL Query 

SELECT *
FROM "Person"
WHERE "Person".age > 35 AND "Person".hair = 'blonde'

NAMEIDAGEHAIR
1 rows

Bridget

2

40

blonde

Cypher Query 

MATCH (person:Person)
WHERE HAS (person.name) AND person.age > 35 AND person.hair = 'blonde'
RETURN person

person
1 row

Node[1]{name:"Bridget",id:2,age:40,hair:"blonde"}