Excluding label names in simple Neo4j Query

Question

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!

match (n:X, (r:Y) return n, r <-- I don't want to do this as I have too many labels to include — Ed Baker, Sep 28 '15 at 06:48

score 67 · Accepted Answer · edited Apr 12 '20 at 13:57

67

This should do it:

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

edited Apr 12 '20 at 13:57

Adrian Mole

49,934
160
51
83

answered Sep 28 '15 at 06:58

Oskar Hane

1,824
13
8

Great @EdBaker, please mark my answer as correct to help others. – Oskar Hane Sep 28 '15 at 07:03

score 0 · Answer 2 · answered Oct 29 '22 at 21:38

0

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']]

answered Oct 29 '22 at 21:38

Kelvin Lawrence

14,674
2
16
38

Excluding label names in simple Neo4j Query

2 Answers2

Linked