troubleshooting Question

mysql concatenate question

Avatar of BR
BRFlag for Turkey asked on
3 Comments2 Solutions132 ViewsLast Modified:
Dear Experts,

I select the mobile phone numbers from my database where the length of the mobile number is one missing.
SELECT * FROM `mytable` WHERE length(mobile)='10'

the mobile numbers are supposed to be 11 characters, however I have 170 mobile number's length is 10, starting without 0

what I need to do is to select these 170 numbers and concatenate with 0

how can I do that with mysql?
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros