UPDATE table SET country = *, city = *, phone = * WHERE name = '*' [values are test_country test_city test_phone test_name] UPDATE table SET country = *, phone = * WHERE name = '*' [values are test_country test_phone test_name] UPDATE table SET city = * WHERE name = '*' [values are test_city test_name]