mysql substring remove last 5 characters code example Example: mysql remove last character LEFT(col,length(col)-1)