Delete all relationships except for those in list

[tarendran_vivek]

Hi,

I am trying to delete only some of the relationships attached to a node while not deleting those that I have matched by using MATCH then using WHERE NOT EXISTS.
In the example below, I have already created a node (:Person {name:'John'}) and then I MERGE 3 nodes (:Car) with names (test1, test2, test3). However, when I run the query it doesn't delete the intended relationship but instead it deletes all relationships.

UNWIND [{name:'test1'}, {name:'test2'}] AS test
MATCH (p:Person {name:'John'})
OPTIONAL MATCH (p)-[d:DRIVES]->(c:Car)
WHERE NOT EXISTS((p)-[:DRIVES]->(c:Car {name:test.name}))
DELETE d
RETURN p

Thanks in advance .

[Cobra]

Hello @tarendran.vivekanand

UNWIND [{name:'test1'}, {name:'test2'}] AS test
MATCH (p:Person {name:'John'})-[d:DRIVES]->(c:Car)
WHERE NOT EXISTS((p)-[:DRIVES]->(c:Car {name:test.name}))
DETACH DELETE d

Regards,
Cobra

[tarendran_vivek]

Hello @Cobra
Unfortunately the query you gave still deletes all relationships
Basically im trying to delete all relationships except those that are in the list
Also, I just tested the query works when the list is just 1

UNWIND [{name:'test1'}] AS test

[Cobra · Accepted solution]

I suggest you to do like this otherwise it will deletes all the elements of the list but keeping the first:

MATCH (p:Person {name:'John'})-[d:DRIVES]->(c:Car)
WHERE NOT c.name IN ['test1', 'test2']
DETACH DELETE d

Regards,
Cobra

[tarendran_vivek]

Thanks @Cobra

However there was a slight error NOT has to come first otherwise will get error.

MATCH (p:Person {name:'John'})-[d:DRIVES]->(c:Car)
WHERE NOT c.name IN ['test1', 'test2']
DETACH DELETE d

[Cobra]

Oh yeah, Python habits
I updated my answer, thank you