asked on mysql concatenate question
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?
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?
PHPMySQL Server
Last Comment
BR
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thank you both