Formatting field data in phpmyadmin database column

Question

Im trying to change the display of numbers of a certain column in my database. The table is called member_records and the specific field is called userID (int type) and the data under userID varies in length(in terms of number of characters) but Im only interested in the last 7 digits. Anyone with any idea how I can make the field userID display only the last 7 digits?

varies in length(in terms of number of characters)... What is the type of the column? Int or Varchar? - BTW: this question has nothing to do with phpmyadmin — B001ᛦ
– B001ᛦ, Commented May 2, 2019 at 9:56
Im only interested in the last 7 digits... So why don't you just store the last 7 digits — B001ᛦ
– B001ᛦ, Commented May 2, 2019 at 10:00
@B001 Because Im not the one doing the input. Thats user input — user11363820
– user11363820, Commented May 2, 2019 at 10:02

Nick · Accepted Answer · 2019-05-02 10:08:36Z

1

You can just take the modulus with 10,000,000 to extract the last 7 digits of an integer. For example,

create table member_records (user_id int);
insert into member_records values
(12359725),
(445),
(923587356),
(389475679);

SELECT user_id % 10000000 AS user_id
FROM member_records

Output:

Demo on dbfiddle

answered May 2, 2019 at 10:08

Nick

147k23 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user11363820 Over a year ago

Thank you! This has been very helpful

Collectives™ on Stack Overflow

Formatting field data in phpmyadmin database column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related