update part of string in database when condition meets

Question

This is my database structure. I want to update mobileno column where length(mobileno)!= 13 , and add 88 string before them . Like 017126875493 becomes 88017126875493

Onkar Musale · Accepted Answer · 2019-04-11 04:57:56Z

1

You can try using concat()

UPDATE tablename SET mobileno = concat('88',mobileno)
WHERE length(mobileno) != 13;

edited Apr 11, 2019 at 4:57

Onkar Musale

91910 silver badges26 bronze badges

answered Apr 11, 2019 at 4:51

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

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

Comments

5hakir · Accepted Answer · 2019-04-11 04:56:38Z

0

Solved it by using concat()

UPDATE passenger.mobileno
SET passenger.mobileno= CASE
   WHEN length(passenger.mobileno)=11 THEN CONCAT("88",passenger.mobileno)
   ELSE passenger.mobileno

answered Apr 11, 2019 at 4:56

5hakir

12910 bronze badges

Collectives™ on Stack Overflow

update part of string in database when condition meets

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related