remove last number from string in mysql code example Example: mysql remove last character LEFT(col,length(col)-1)