Cut mysql data when selecting

Programming in mysql: Cut mysql data when selecting on newest questions tagged mysql – Stack Overflow

I have a table with “unique“ values. The problem is that the program, which adds these values also adds 3 different postfixs to the value (2 characters in the end of the value). As a result, I have three variable with three postfixs. So i need get only unique values from bd – somehow sort it out without the last two characters. Are any ideas?

source: http://stackoverflow.com/questions/11898976/cut-mysql-data-when-selecting
Programming in mysql: programming-in-mysql