neo4j search nodes, relationships contains string

Question

MATCH (n) WHERE n.name =~ '(?i).*SUBSTRING.*' RETURN n;

results in

Expected 1 to be a java.lang.String, but it was a java.lang.Long (cause of =~)

Is there a way to for strings case insensitive in all possible places?

for relationships `match n-[r]-() where type(r)=~ '(?i).* SUBSTRING.*' return distinct type(r)` — Pavel Vanchugov, Jun 08 '15 at 11:02

score 3 · Accepted Answer · answered Jun 08 '15 at 10:31

3

If

MATCH (n) WHERE str(n.name) =~ '(?i).*SUBSTRING.*' RETURN n;

works then you've got a node with a name property that isn't a String, and that's why the error

answered Jun 08 '15 at 10:31

Luanne

neo4j search nodes, relationships contains *string*