Update MySQL column in place

Question

I have a column in my table as number of type varchar(15). This contains phone numbers. I would like to append a constant country code to each of the phone numbers. i.e if the number is 1234567890 I want it to be updated to 911234567890 where '91' is the country code. Is there a simple way to do this or do I have to run a loop through all the rows?

Sorin · Accepted Answer · 2014-09-08 09:37:30Z

3

UPDATE table SET number = CONCAT('91', number)

answered Sep 8, 2014 at 9:37

Sorin

5,4662 gold badges21 silver badges45 bronze badges

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

Comments

Israr · Accepted Answer · 2014-09-08 09:45:32Z

2

try this:

UPDATE tablename SET number=concat('91',number);

answered Sep 8, 2014 at 9:45

Israr

1621 silver badge13 bronze badges

Collectives™ on Stack Overflow

Update MySQL column in place

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related