mysql 逗号分隔 多行_MySQL：将逗号分隔列表分割成多行

在MySQL中可以实现如下

SELECT id, length FROM vehicles WHERE id IN ( 117, 148, 126)

+---------------+

| id | length |

+---------------+

| 117 | 25 |

| 126 | 8 |

| 148 | 10 |

+---------------+

SELECT id,vehicle_ids FROM load_plan_configs WHERE load_plan_configs.id =42

+---------------------+

| id | vehicle_ids |

+---------------------+

| 42 | 117, 148, 126 |

+---------------------+

现在得到逗号分隔的车辆名称的长度使用下面的查询

Output

SELECT length

FROM vehicles, load_plan_configs

WHERE load_plan_configs.id = 42 AND FIND_IN_SET(

vehicles.id, load_plan_configs.vehicle_ids

)

+---------+

| length |

+---------+

| 25 |

| 8 |

| 10 |

+---------+