SELECT
SUBSTRING_INDEX( age, ‘,’, 1 ) hous,
SUBSTRING_INDEX( SUBSTRING_INDEX( age, ‘,’,- 2 ), ‘,’, 1 ) fen,
SUBSTRING_INDEX( SUBSTRING_INDEX( age, ‘,’,- 2 ), ‘,’,- 1 ) miao
FROM
aaa
WHERE
id =1
aaa是表名 age就是分割的字符串例如age:111,2222,333
SELECT
SUBSTRING_INDEX( age, ‘,’, 1 ) hous,
SUBSTRING_INDEX( SUBSTRING_INDEX( age, ‘,’,- 2 ), ‘,’, 1 ) fen,
SUBSTRING_INDEX( SUBSTRING_INDEX( age, ‘,’,- 2 ), ‘,’,- 1 ) miao
FROM
aaa
WHERE
id =1
aaa是表名 age就是分割的字符串例如age:111,2222,333