UPDATE statement using the same table in subquery myisam mysql sql SELECT vl1.phone_number, vl1.first_name, CONCAT( SUBSTRING( ( SELECT vl2.phone_number FROM list as vl2 …