A colleague is doing some maintenance of categories in a jobs database. One of the things he was asked to do was merge "Food and Beverage Workers" (code = "FOO") with "Bar Staff" (code = "BAR"). This necessitated running a query something like this:
UPDATE occupation SET category = "FOO" WHERE category = "BAR"
