SELECT DISTINCT (SUBSTRING_INDEX( REPLACE ( 列名称, CONCAT( SUBSTRING_INDEX( 列名称, '"key名称":', 1 ), '"key名称":"' ), '' ), '"', 1 )) AS VALUE FROM 表名称
SELECT DISTINCT (SUBSTRING_INDEX( REPLACE ( 列名称, CONCAT( SUBSTRING_INDEX( 列名称, '"key名称":', 1 ), '"key名称":"' ), '' ), '"', 1 )) AS VALUE FROM 表名称