删除表中FTYPE这一列的后缀.JPG,具体操作如下: update S_ATTACH_FILE set FTYPE = substr(FTYPE,1,2) where FTYPE LIKE '%.JPG%'