<div id="content\_views" class="markdown\_views prism-github-gist"> <!-- flowchart 箭头图标 勿删 --> <svg xmlns="http://www.w3.org/2000/svg" style="display: none;"> <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path> </svg> <ol> <li>模糊查询<br> <code>match(emp) where emp.name =~'.\*haha.\*' return emp</code></li> <li>现有节点创建关系</li> </ol> <pre class="prettyprint"><code class="has-numbering hljs less" onclick="mdcp.signin(event)" style="position: unset;"><span class="hljs-selector-tag">MATCH</span> (<span class="hljs-attribute">cust</span>:Customer),(<span class="hljs-attribute">cc</span>:CreditCard) <span class="hljs-selector-tag">CREATE</span> (cust)<span class="hljs-selector-tag">-</span><span class="hljs-selector-attr">\[r:DO\_SHOPPING\_WITH{shopdate:"12/12/2014",price:55000}\]</span><span class="hljs-selector-tag">-</span>>(cc) <span class="hljs-selector-tag">RETURN</span> <span class="hljs-selector-tag">r</span> <div class="hljs-button signin" data-title="登录后复制"></div></code></pre> <ol start="3"> <li>Skip 和limit</li> </ol> <pre class="prettyprint"><code class="has-numbering hljs less" onclick="mdcp.signin(event)" style="position: unset;"><span class="hljs-selector-tag">MATCH</span> (<span class="hljs-attribute">emp</span>:Employee) <span class="hljs-selector-tag">RETURN</span> <span class="hljs-selector-tag">emp</span> <span class="hljs-selector-tag">SKIP</span> <span class="hljs-selector-tag">2</span> <span class="hljs-selector-tag">limit</span> <span class="hljs-selector-tag">1</span> <div class="hljs-button signin" data-title="登录后复制"></div></code></pre> <ol start="4"> <li>where 条件查询</li> </ol> <pre class="prettyprint"><code class="has-numbering hljs vbnet" onclick="mdcp.signin(event)" style="position: unset;">MATCH (emp:Employee) <span class="hljs-keyword">WHERE</span> emp.name = <span class="hljs-comment">'Abc'</span> <span class="hljs-keyword">RETURN</span> emp <div class="hljs-button signin" data-title="登录后复制"></div></code></pre> <ol start="5"> <li>IN</li> </ol> <pre class="prettyprint"><code class="has-numbering hljs css" onclick="mdcp.signin(event)" style="position: unset;"><span class="hljs-selector-tag">MATCH</span> (<span class="hljs-selector-tag">e</span><span class="hljs-selector-pseudo">:Employee)</span> <span class="hljs-selector-tag">WHERE</span> <span class="hljs-selector-tag">e</span><span class="hljs-selector-class">.id</span> <span class="hljs-selector-tag">IN</span> <span class="hljs-selector-attr">\[123,124\]</span> <span class="hljs-selector-tag">RETURN</span> <span class="hljs-selector-tag">e</span><span class="hljs-selector-class">.id</span>,<span class="hljs-selector-tag">e</span><span class="hljs-selector-class">.name</span>,<span class="hljs-selector-tag">e</span><span class="hljs-selector-class">.sal</span>,<span class="hljs-selector-tag">e</span><span class="hljs-selector-class">.deptno</span> <div class="hljs-button signin" data-title="登录后复制"></div></code></pre> 原文地址：https://blog.csdn.net/qq\_32662595/article/details/79876345 </div>
