我需要的是一个mysql查询，它只选择| ~ |前面的[data]列中的值。
之前要注意的一点是数字 |~| 必须是唯一的。
它不会两次显示相同的数字。
查询

SELECT
 DISTINCT 
   SUBSTRING (
       record_data.column
     , LOCATE('|~|', record_data.`column` , number_generator.number) - 1
     , 1
   ) AS number
FROM (
  SELECT 
   @row := @row + 1 AS number
  FROM (
    SELECT 0 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9
  ) record_1
  CROSS JOIN (
    SELECT 0 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9
  ) record_2    
  CROSS JOIN (
    SELECT 0 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9
  ) record_4
  CROSS JOIN (
    SELECT 0 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9
  ) record_5     
  CROSS JOIN (
    SELECT @row := 0 
  ) AS init_user_params
) AS number_generator

CROSS JOIN (

SELECT 
 *
FROM (
  SELECT 'value 1|~|value 1 value 2|~|value 2 value 3|~|value 3' AS `column`
) AS record 

) AS record_data

WHERE
   LOCATE('|~|', record_data.`column` , number_generator.number) <> 0

结果

| number |
| ------ |
| 1      |
| 2      |
| 3      |

演示