MySQL Forums
Forum List  »  Newbie

Remove last digit from all data in column
Posted by: Joshua Anderson
Date: November 26, 2017 08:59AM

Hello,

Just asking if this is possible:

I have a mysql database 'data' and a column 'count' which contains numbers such as

3741
49215
345
4686794

I was wondering if there is a possibility to remove the last figure from each number in this column, so there will be these values:

374
4921
34
468679

(for 100,000 rows so i can't do it manually :) )

Thank you!

Options: ReplyQuote


Subject
Written By
Posted
Remove last digit from all data in column
November 26, 2017 08:59AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.