Space Race/MATCH Tutorial: Difference between revisions
From NoSQLZoo
ChrisHouston (talk | contribs) No edit summary |
ChrisHouston (talk | contribs) No edit summary |
||
| Line 19: | Line 19: | ||
==Born in Russia== | ==Born in Russia== | ||
<div class="q nonum" data-lang="neo4j"> | <div class="q nonum" data-lang="neo4j"> | ||
<p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual</p> | <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p> | ||
<p class='strong'>Show the Surnames of Astronauts born in Russia rather than the USA <p> | <p class='strong'>Show the Surnames of Astronauts born in Russia rather than the USA <p> | ||
<pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c. | <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev ='usa' RETURN n.surname, c.name;</nowiki> | ||
</pre> | </pre> | ||
<pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c. | <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev= 'ru' RETURN n.surname;</nowiki> | ||
</pre> | </pre> | ||
</div> | </div> | ||
{{Acknowledgements}} | {{Acknowledgements}} | ||
Revision as of 09:11, 27 November 2019
Visualisation
Click here for 3d graph visualisation
Institutions
Use MATCH and RETURN to show nodes that are Institutions rather than Astronauts
Show Institutions instead of Astronauts
MATCH(n:Astronaut) RETURN n;
MATCH(n:Institution) RETURN n;
Born in Russia
Use WHERE to specify conditions and the . operator to access individual properties of a node.
Show the Surnames of Astronauts born in Russia rather than the USA
MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev ='usa' RETURN n.surname, c.name;
MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev= 'ru' RETURN n.surname;
Acknowledgements
NoSQLZoo is made possible by the following open-source technologies: