Got it, let's fix that multi-hop path query for your transit system graph! The issue with your initial MATCH statement is that it only explicitly defines a single "Stop → Connection → Stop" step—we need to tell Cypher to repeat that pattern as many times as needed to get from your start to end stop.

基础多跳查询语句 #

First, here's the core Cypher query that will match any number of hops (1 or more) between your start and end stops, following your (Stop)-[:HAS]->(Connection)-[:TO]->(Stop) pattern:

MATCH path = (start:Stop {name: '你的起始站点名'})-((:HAS)->(:Connection)-[:TO]->(:Stop))+-(end:Stop {name: '你的目标站点名'})
WHERE start <> end  // 确保不是同一个站点
RETURN path

Let's break this down:

• ((:HAS)->(:Connection)-[:TO]->(:Stop))+: The + means "repeat this path fragment at least once". This is the key part—it tells Cypher to loop through your Stop→Connection→Stop pattern as many times as needed to reach the end stop.
• path: Captures the entire path from start to end, so you can visualize it in Neo4j Browser or extract details from it.

进阶用法 #

If you need more than just the raw path, here are some common variations:

1. 获取路径上的所有节点列表

   MATCH path = (start:Stop {name: '起始站'})-((:HAS)->(:Connection)-[:TO]->(:Stop))+-(end:Stop {name: '终点站'})
   RETURN path, nodes(path) AS all_nodes, [n in nodes(path) | n.name] AS node_names
   

   This returns the full path, a list of all nodes in the path, and a simplified list of just their names for easy reading.

2. 限制最大跳数（优化性能）
   For large graphs, unlimited multi-hop queries can get slow. Add a range to limit how many hops Cypher will check (e.g., max 5 hops):

   MATCH path = (start:Stop {name: '起始站'})-((:HAS)->(:Connection)-[:TO]->(:Stop))*1..5-(end:Stop {name: '终点站'})
   RETURN path
   

   The *1..5 means "repeat this pattern 1 to 5 times".

3. 只提取中间的Connection节点
   If you only care about the connections between stops, filter the path nodes:

   MATCH path = (start:Stop {name: '起始站'})-((:HAS)->(:Connection)-[:TO]->(:Stop))+-(end:Stop {name: '终点站'})
   RETURN [node in nodes(path) WHERE node:Connection] AS connections_used
   

为什么你的初始查询只返回1跳？ #

Chances are your original MATCH looked something like this:

// 只能匹配1跳的路径
MATCH (start:Stop)-[:HAS]->(:Connection)-[:TO]->(end:Stop)
RETURN start, end

This only defines a single Stop→Connection→Stop chain, so Cypher won't look beyond that. The + or * syntax for repeating path fragments is what unlocks multi-hop matching.

内容的提问来源于stack exchange，提问作者Bennet L.