How can I make a string contain filter on Neo4j Cypher

Question

I need to make a string contain filter in Neo4J. The idea is simple.

A good example is that I need to retrieve from a database of persons all the people that contain in his name the car substring.

How can I do this?

score 32 · Answer 1 · edited Aug 28 '23 at 13:23

32

As an additional update, from neo4j 3.0 it may be more readable to use:

MATCH(n)
WHERE n.name CONTAINS 'car'
RETURN n

(Edited to include Maciej fix to my response, thank you!)

edited Aug 28 '23 at 13:23

Philippe Fanaro

answered Aug 19 '16 at 11:20

yawmoght

2

This approach works but you must surround car in quotes like so: MATCH(n) WHERE n.name CONTAINS 'car' RETURN n – Maciej Sep 11 '16 at 01:42
2

Can you use contains with a list of words? – nid May 27 '20 at 22:29

score 20 · Accepted Answer · answered Jun 07 '14 at 11:39

You can use regular expressions to match a part of a name, for example:

MATCH (n)
WHERE n.name =~ '.*car.*'
RETURN n

If you have the label 'Person' assigned to all people in your database, the query would be:

MATCH (n:Person)
WHERE n.name =~ '.*car.*'
RETURN n

2 Answers2