Update phone add zero 27 Aug, 2019 MySQL 0 Comments 0 Source code UPDATE vtiger_account SET phone = concat("0",phone) WHERE LEFT(phone, 1) != "0"