Operators

Sample data

The following examples use this graph:

SELECT * FROM cypher('graph_name', $$
CREATE (:Person {name: 'John'}),
       (:Person {name: 'Jeff'}),
       (:Person {name: 'Joan'}),
       (:Person {name: 'Bill'})
$$) AS (result agtype);

STARTS WITH

Returns nodes whose property begins with the specified prefix.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name STARTS WITH "J"
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
 "Jeff"
 "Joan"
(3 rows)

ENDS WITH

Returns nodes whose property ends with the specified suffix.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name ENDS WITH "n"
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
 "Joan"
(2 rows)

CONTAINS

Returns nodes whose property contains the specified substring.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name CONTAINS "o"
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
 "Joan"
(2 rows)

Basic string matching

Without special characters, =~ behaves like the = operator.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name =~ 'John'
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
(1 row)

Case-insensitive matching

Add (?i) at the start of the pattern to make the match case-insensitive.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name =~ '(?i)JoHn'
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
(1 row)

Wildcard .

. matches any single character.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name =~ 'Jo.n'
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
 "Joan"
(2 rows)

Wildcard *

* matches zero or more occurrences of the preceding character.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name =~ 'Johz*n'
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
(1 row)

Operator +

+ matches one or more occurrences of the preceding character.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name =~ 'Bil+'
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "Bill"
(1 row)

Combining . and *

Use .* together to match the rest of a string.

SELECT * FROM cypher('graph_name', $$
 MATCH (v:Person)
 WHERE v.name =~ 'J.*'
 RETURN v.name
$$) AS (names agtype);

Result:

 names
--------
 "John"
 "Jeff"
 "Joan"
(3 rows)