Driver_Database_Driver_MySQL::_compile_update

protected function _compile_update($builder)
{
    // Start an update query
    $query = 'UPDATE ' . $this->quote_table($builder['table'],false);

    // Add the columns to update
    $query .= ' SET ' . $this->_compile_set($builder['set'], $builder['parameters']);

    if (!empty($builder['where']))
    {
        // Add selection conditions
        $query .= ' WHERE ' . $this->_compile_conditions($builder['where'], $builder['parameters']);
    }

    if (!empty($builder['order_by']))
    {
        // Add sorting
        $query .= ' ' . $this->_compile_order_by($builder['order_by']);
    }

    if ($builder['limit'] !== null)
    {
        // Add limiting
        $query .= ' LIMIT ' . $builder['limit'];
    }

    if ($builder['offset'] !== null)
    {
        // Add offsets
        $query .= ' OFFSET ' . $builder['offset'];
    }

    return $query;
}