Syntax

Cypher Cheat Sheet - Neo4j Documentation Cheat Sheet

[USE]
[MATCH [WHERE]]
[OPTIONAL MATCH [WHERE]]
[WITH [ORDER BY] [SKIP] [LIMIT] [WHERE]]
RETURN [ORDER BY] [SKIP] [LIMIT]

MATCH

MATCH is similar to SELECT in SQL.

• MATCH(n): match all node
• MATCH (n:Person)-[:KNOWS]->(m:Person): Match nodes and relationships involved in the relationship
• MATCH (a:Person {name: 'Andy'}): Similar to WHERE, find node by property
• MATCH p1=(u1:User)-[:COMMENTED]->(c1:Comment)-[:COMMENTED_ON]-(q:Question): Relationship can be chained. User commented comment “c1” that is commented on question “q”

WHERE

Same as SQL WHERE, acts as a filter.

• WHERE n.property <> $value
• WHERE r:R1|R2: OR relationship
• MATCH (a:Person)-[r:KNOWS WHERE r.since < minYear]->(b:Person): relationship used as predicate in a WHERE clause.