Update area code sql

Question

if i needed to change all area codes that start with (81) to (51) in the phone column of a database. How would I do that?

Answer 1

Hello. Something like this could help: "UPDATE Table SET colum1 = value1, column2 = value2 WHERE area_code_column LIKE '81%' OR area_code_column LIKE '51%' "