Remove last character from sql field.

update set = left(, length()-1);