示例代码 例:从 'a:10;b:20;c:30;d:40’中取中c对应的value SELECT SUBSTRING_INDEX( REPLACE(a, CONCAT(SUBSTRING_INDEX(t.a, 'c:', 1),'c:'),'') ,';' ,1 ) FROM ( SELECT 'a:10;b:20;c:30;d:40' AS a ) t ;