WHERE

Filter results with 15+ predicates: comparisons, boolean logic, string matching, null checks, regex, and list membership.

MATCH (n:Person)
WHERE n.age >= 25 AND n.name STARTS WITH 'A'
RETURN n.name, n.age

Operators#

Operator	Example	Since
`=`	`WHERE n.age = 30`	0.2.0
`<>`	`WHERE n.name <> 'Bob'`	0.6.0
`>`, `<`, `>=`, `<=`	`WHERE n.age > 25`	0.6.0
`AND`	`WHERE n.age > 25 AND n.age <= 35`	0.6.0
`OR`	`WHERE n.age < 20 OR n.age > 60`	0.6.0
`NOT`	`WHERE NOT n.name = 'Carol'`	0.6.0
`CONTAINS`	`WHERE n.name CONTAINS 'li'`	0.6.0
`STARTS WITH`	`WHERE n.name STARTS WITH 'A'`	0.6.0
`EXISTS()`	`WHERE EXISTS(n.email)`	0.6.0

Examples#

Comparison#

MATCH (n:Person) WHERE n.age >= 25 AND n.age < 35 RETURN n.name

String predicates#

MATCH (n:Person) WHERE n.name STARTS WITH 'A' RETURN n

Existence check#

MATCH (n:Person) WHERE EXISTS(n.email) RETURN n.name, n.email

Compound boolean#

MATCH (n:Person) WHERE n.age > 25 AND NOT n.name = 'Carol' RETURN n.name

See Also#

MATCH — pattern matching
RETURN — projection

Try it

Open ↗⌘↵ to run

Loading engine…