MySql 中的字符函数

截取

substring(str, index)

select substring(file_path, -10) from tbdownload limit 10;
select substring(file_path, 5) from tbdownload limit 10;

替换

select replace(file_path, "jpg", "png") from tbdownload limit 10;