Update queries

Now that we've seen INSERT queries, let's take a look at how we can update existing records. Say we wanted to update one of our player records; we will do so as follows:

$result = $database->update('players')
  ->fields(['data' => serialize([
    'sport' => 'swimming', 
    'feature' => 'This guy can swim'
  ])])
  ->condition('name', 'Micheal P.')
  ->execute();

UPDATE queries are like INSERT ones, except that they take a condition() to figure out which records to update (all that match the condition). Leaving this out will update all records, naturally. Using the fields() method, we will simply specify which columns are getting updated, and with what. If we leave out a column, it will stay untouched. Lastly, the result of this query is the total number of records affected.