Ed Baker
Ed Baker

Reputation: 663

Excluding label names in simple Neo4j Query

Usually I can find everything I need already on SO but not this time. I'm looking for a very simple way to exclude labels, for example (pseudo code):

match (n) where n not in (Label1, Label2) return n

Sorry about crappy query. In short I have labels x,y,z and I want to return all of them apart from z.

Thnx!

Upvotes: 34

Views: 17108

Answers (2)

Kelvin Lawrence
Kelvin Lawrence

Reputation: 14371

If you have a long list of labels you want to exclude, I find this syntax to be helpful:

match (n)
where not labels(n) in [['label1'],['label2'],['label3']]

Upvotes: 2

Oskar Hane
Oskar Hane

Reputation: 1882

This should do it:

MATCH (n)
WHERE NOT n:Label1 AND NOT n:Label2
RETURN n;

Upvotes: 72

Related Questions