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