Skip to main content

Cypher clauses overview

The Cypher language enables users to perform standard database operations by using the following clauses:

  • CALL - calls a subquery inside the query
  • CREATE - creates new nodes and relationships
  • DELETE - deletes nodes and relationships
  • LOAD CSV - loads data from CSV file
  • MATCH - searches for patterns
  • MERGE - creates patterns if they don't exist
  • OPTIONAL MATCH - behaves the same as MATCH, but when it fails to find the pattern it fills missing parts of the pattern with null values
  • REMOVE - removes labels and properties
  • RETURN - defines what will be presented to the user in the result set
  • SET - adds new or updates existing labels and properties
  • UNION and UNION ALL - combines results from multiple queries
  • UNWIND - unwinds a list of values as individual rows
  • WHERE - filters the matched data
  • WITH - combines multiple reads and writes