Updating an existing table value based on a certain condition.
Syntax:
Update <table-name>
set column = <new value>
where other column = condition
I’ve had to ran an update on an existing table for an instance where the logic for creating a product type column needed to be updated based on another column.