mysql 按某字段的一部分分组

2024-11-27 11:47:02
推荐回答(1个)
回答1:

select image_file from (select substring_index(image,'/',-1) as image_file from 表) as a1 group by image_file;