I have to get last 5 numbers using mysql.
My values are like
I have to get only last five char . How can I do this in query?
You can do this with RIGHT(str,len) function. Returns the rightmost len characters from the string str,
SELECT RIGHT(columnname,5) as yourvalue FROM tablename
Answered By – user319198