Update a column (COLUMN1) value to 'abc' for all records having the value of 'xyz' in another column (COLUMN2)

Search Database SQL / Scripts

Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

Database Queries/Scripts

Sample 1. Update a column (COLUMN1) value to 'abc' for all records having the value of 'xyz' in another column (COLUMN2)

update TABLE_NAME set COLUMN1 = 'abc' where COLUMN2 = 'xyz'

_{Like Feedback update table update column DML}