String Functions

Basic String Functions

  1. toString() - Convert to string
  2. toUpper() - Convert to uppercase
  3. toLower() - Convert to lowercase
  4. trim() - Remove leading and trailing whitespace
  5. replace() - Replace string
  6. substring() - Extract substring
  7. size() - Return string length
  8. split() - Split by delimiter
  9. reverse() - Reverse string
  10. contains() - Check containment
  11. startsWith() - Check start
  12. endsWith() - Check end
MATCH (p:Person)
RETURN ID(p),LOWER(p.character)

Aggregate Functions

MATCH (p:Person)
RETURN MAX(p.money),SUM(p.money)

Relationship Functions

match p = (:Person{name: "wzk5"})-[r:Friend]-(:Person) return STARTNODE(r);

Shortest Path

MATCH p=shortestPath( (node1)-[*]-(node2) )
RETURN length(p), nodes(p)

Multi-depth Relationship Queries

Direct Relationship Node Query

match (na:Person{name:"wzk1"})-[re]->(nb:Person)-[re2]->(nc:Person) return na,re,nb,re2,nc

Using Depth Operators

match data = (na:Person{name:"wzk1"})-[*1..2]-(nb:Person) return data