add mobile prefix in existing mobile field in mysql I have mysql table 'USERS' which have a column name 'MOBILE" which contains customer mobile numbers in following format

333123456
333123457


I want to add 092 in starting of every number so that it should be like this

092333123456
092333123457


there are hundreds of mobile records I have to update, so is tehre any query I can run to accomplish this task?
A simple UPDATE should suffice. Make sure your column isn't a numeric type or you will lose leading zeroes.

UPDATE USERS SET MOBILE = CONCAT('092', MOBILE)


Also think about the possibility of keeping the prefix on a separate column, it would be easier to update and it won't be mixed up with the actual mobile number.