remove last characters from string mysql code example

Example: mysql remove last character

LEFT(col,length(col)-1)