Find neo4j nodes where property is not set

Question

What's a cypher query to find a node where a property doesn't exist? 2 nodes: A = {foo: true, name: 'A'}, B = { name: 'B'}

need to find B because it doesn't have foo, i.e. B.foo is not set

Answer 1

MATCH (f) WHERE f.foo IS NULL RETURN f

Answer 2

As Michael Hunger mentioned

MATCH (n) WHERE NOT EXISTS(n.foo) RETURN n

On older versions of Neo4j you can use HAS:

# Causes error with later versions of Neo4j
MATCH (n) WHERE NOT HAS(n.foo) RETURN n