Neo4j WHERE Clause

In Neo4j CQL WHERE clause is used to specify a condition to retrieve the exact data which we want to retrieve.

Syntax:

MATCH (label)  
WHERE label.country = "property" 
RETURN label 

Example:

Let's use WHERE clause to return all the nodes from the Neo4j database where POB of the node (player) is "Chennai".

MATCH (player)  
WHERE player.POB = "Chennai" 
RETURN player 

Output:

You can see it in tabular form to verify:

WHERE Clause with Multiple Conditions

You can use "WHERE" clause with multiple conditions.

Syntax:

MATCH (stu:Student)  
WHERE stu.name = 'Abc' AND stu.name = 'Xyz' 
RETURN stu 

Example:

Use the following query to filters the nodes in the Neo4j database using two conditions.

MATCH (player)  
WHERE player.name = "Sachin Tendulakar" AND player.YOB = 1968 
RETURN player

Output:

In the above example, we have used "AND" clause to specify multiple conditions.

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India