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?