select name,if(SUBSTRING_INDEX(name, '.', -1)=name,null,SUBSTRING_INDEX(name, '.', -1)) suffix from tran_file