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
`=`	`WHERE n.age = 30`
`<>`	`WHERE n.name <> 'Bob'`
`>`, `<`, `>=`, `<=`	`WHERE n.age > 25`
`AND`	`WHERE n.age > 25 AND n.age <= 35`
`OR`	`WHERE n.age < 20 OR n.age > 60`
`NOT`	`WHERE NOT n.name = 'Carol'`
`CONTAINS`	`WHERE n.name CONTAINS 'li'`
`STARTS WITH`	`WHERE n.name STARTS WITH 'A'`
`EXISTS()`	`WHERE EXISTS(n.email)`

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…