NEO4J -模糊查询

1. 模糊查询

match(emp) where emp.name =~'.*haha.*' return emp

2. 现有节点创建关系

MATCH (cust:Customer),(cc:CreditCard) 
CREATE (cust)-[r:DO_SHOPPING_WITH{shopdate:"12/12/2014",price:55000}]->(cc) 
RETURN r

3. Skip 和limit

MATCH (emp:Employee) 
RETURN emp
SKIP 2 limit 1

4. where 条件查询

MATCH (emp:Employee) 
WHERE emp.name = 'Abc'
RETURN emp

5. IN

MATCH (e:Employee) 
WHERE e.id IN [123,124]
RETURN e.id,e.name,e.sal,e.deptno

6. 删除所有节点中的单节点

MATCH (n)
WHERE size((n)--())=0
DELETE (n)