我的查询语句是这样

SELECT cas_file_no,cas_typ_bid,cas_code,cas_name,SUBSTRING_INDEX(c.att_path, '/', -1) AS path_name,REPLACE(CONCAT('https://192.168.28.8:8443/CCDS/downloadAction.do?op=getStreamlnfo&fileId=',COALESCE(c.att_id, ''),'&path=',COALESCE(c.att_path, '')),'/vis/','%2Fvis%2F') AS path

FROM DY_BANK_CASE_NEW a

LEFT JOIN DY_VIS_RECORD b ON a.cas_id = b.vr_cas_id

LEFT JOIN  DY_ATTACHMENT_NEW c ON b.vr_id = c.att_fk_id

WHERE a.cas_file_no = '${cas_no}'and cas_typ_bid='${cas_typ}';

在网页上的展示是这样

想要的效果是点击路径是可以在线查看后面链接图片，应该怎么做？

完整路径是：REPLACE(CONCAT('https://192.168.28.8:8443/CCDS/downloadAction.do?op=getStreamlnfo&fileId=',COALESCE(c.att_id, ''),'&path=',COALESCE(c.att_path, '')),'/vis/','%2Fvis%2F') AS path

数据路径是截取出来的：SUBSTRING_INDEX(c.att_path, '/', -1) AS path_name