Ver originalselect if(right(palabra,1)='s',substring(palabra,1,length(palabra)-1,palabra) from tabla;
Ver originalupdate tabla set palabra=if(right(palabra,1)='s',substring(palabra,1,length(palabra)-1,palabra);