How to append prefix with XXX and retrieve the last 4 digits from a MySQL table?

Claim your Biolink Click Here
0 like 0 dislike
785 views
in Education & Reference by (1.0k points) | 785 views

1 Answer

0 like 0 dislike 
Select right(concat('XXXXXX',SUBSTRING(number, -4)),15) as number from tablename
by

Related questions

1 like 0 dislike
1 answer
How to dump only specific table from MySQL?
asked Jan 15, 2021 in Education & Reference by Simmi (740 points) | 2.5k views
0 like 0 dislike
1 answer
How to dump table structure only from mysql
asked Jul 12, 2018 in Education & Reference by Marc (4.4k points) | 209 views
0 like 0 dislike
1 answer
How to find the youtube video id from mysql from the colomn with below data
asked Jun 18, 2015 in Education & Reference by Simmi (740 points) | 271 views
0 like 0 dislike
1 answer
How to avoid 'copying to tmp table on mysql and speed up MySQL query'
asked May 27, 2014 in Education & Reference by Yogi (400 points) | 410 views
0 like 0 dislike
1 answer
How can we use MySQL Trigger to create a file after insert in a table?
asked Sep 2, 2013 in Education & Reference by Manish | 1.8k views
2 like 0 dislike
1 answer
How to get specific values from a STRING in MYSQL
asked May 12, 2021 in Education & Reference by Sam (1.5k points) | 235 views
0 like 0 dislike
1 answer
How to take mysql backup from A machine & Restore to B machine in centos?
asked Mar 4, 2015 in Education & Reference by Simmi (740 points) | 258 views
3 like 0 dislike
1 answer
MySQL Trigger - How to concatenate variable with the query?
asked Feb 4, 2014 in Education & Reference by Sam (1.5k points) | 1.4k views
0 like 0 dislike
1 answer
MySQL - Search a string in all fields from every table from a database
asked Sep 6, 2013 in Education & Reference by Asker | 1.9k views
2 like 0 dislike
1 answer
How to replace the part of the string from one column in mysql databse?
asked May 12, 2020 in Education & Reference by Yogi (400 points) | 166 views

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

Most popular tags

Related questions

1,291 questions
1,451 answers
568 comments
4,809 users