title: Neo4j, Match Relationship WHERE AND
body: <p>Hello I am trying to match neo4j relationships using 'WHERE AND'</p>
  
  <p>My example relationiship is: 'User Visits Country'</p>
  
  <p>I create it as so...</p>
  
  <pre><code>MATCH (c:Country{Name:Country}) MERGE (u:User{Email:Email,UserID: UserID}) MERGE (u)-[r:Visits]-&gt;(c)
  //Countries are previously created and Users may or may not exist
  </code></pre>
  
  <p>Then I query (This Works):</p>
  
  <pre><code>MATCH (u:User)-[r:Visits]-&gt;(c:Country) where c.Name='France' or c.Name='Spain' return u
  </code></pre>
  
  <p>Result: Shows me all users who have visited Spain OR France, even if they have only visited one of two countries.</p>
  
  <p>BUT What Im trying to do is the same exact query, but with 'AND' instead of 'OR'. In which I can get users that have visited both 'France' and 'Spain'.</p>
  
  <pre><code>MATCH (u:User)-[r:Visits]-&gt;(c:Country) where c.Name='France' AND c.Name='Spain' return u
  </code></pre>
  
  <p>Result: 0 nodes and relationship found..</p>
  
  <p>What can I do?</p>