Menu
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?
511
The WITH clause allows query parts to be chained together, piping the results from one to be used as starting points or criteria in the next. It is important to note that WITH affects variables in scope. Any variables not included in the WITH clause are not carried over to the rest of the query.
Administration clauses These comprise clauses used to manage databases, schema and security; further details can found in Database management and Access control. Clause. Description. CREATE | DROP | START | STOP DATABASE. Create, drop, start or stop a database.
CQL stands for Cypher Query Language. Like Oracle Database has query language SQL, Neo4j has CQL as query language.
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!)
139
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
For further information, see http://docs.neo4j.org/chunked/stable/query-where.html#_regular_expressions
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
