Update area code sql

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?

20th Oct 2018, 9:37 PM
Julie Ann
Julie Ann - avatar
1 Answer
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%' "
20th Oct 2018, 9:50 PM
Timo Heinzelmann
Timo Heinzelmann - avatar