Neo4J get node by ID

Question

I am using neo4j for one of my project, there's a node which only has a single property as name, I want to get that node using ID, it already has a ID but when I use this code

MATCH (s:SKILLS{ID:65110}) return s

It returns nothing, heres my node

If the query is wrong then how do I query it using the number

Answer 1

MATCH (s)
WHERE ID(s) = 65110
RETURN s

The ID function gets you the id of a node or relationship. This is different from any property called id or ID that you create.

Answer 2

START should only be used when accessing legacy indexes. It is disabled in Cypher 2.2 3.2 and up.

Neo4j recommends using WHERE ID(n) = , and furthermore states that it will only require a single lookup (does not scan every node to find the matching ID)

WARNING
The answer below is incorrect. It is listed for reference only. See the updated answer above (quoted). The text below is kept for reference only

You can use WHERE ID(s) = 65110, but this will check the ID of every node in your database.

There is a more efficient way to do this:

START s=NODE(517) MATCH(s) RETURN s

Answer 3

you can say:

(n:User) where id(n) >=20 RETURN n

this will return all nodes of type User with node reference ID more than 20

Answer 4

Below cypher query gives you the solution:

MATCH (s:SKILLS) where n.ID contain '65110' return s

Answer 5

Starting with version 5, the function id() has been deprecated. To achieve the same result, you need to use new function elementId

MATCH (n)
WHERE elementId(n) = $id
RETURN n.name

Answer 6

You should prefer create ID property yourself.

Using system created ID is not advisable and should be avoided, for best practice.