mysql delete last character in string code example

Example: mysql remove last character

LEFT(col,length(col)-1)