delete from mysql where last 4 characters code example

Example: mysql remove last character

LEFT(col,length(col)-1)