Update

UPDATE users SET name = ?, updated_at = ? WHERE id = ?

mysql.Update("users").
    Set("name", mysql.Arg("Updated Name")).
    Set("updated_at", mysql.Arg(time.Now())).
    Where(mysql.Quote("id").EQ(mysql.Arg(1)))

UPDATE users SET active = ? 
WHERE created_at < ? AND last_login IS NULL

mysql.Update("users").
    Set("active", mysql.Arg(false)).
    Where(
        mysql.Quote("created_at").LT(mysql.Arg(time.Now().AddDate(0, -6, 0))),
        mysql.Quote("last_login").IsNull(),
    )

UPDATE users u
JOIN user_profiles p ON u.id = p.user_id
SET u.status = ?
WHERE p.verified = ?

mysql.Update("users").As("u").
    Join("user_profiles").As("p").
    On(mysql.Quote("u", "id").EQ(mysql.Quote("p", "user_id"))).
    Set("u.status", mysql.Arg("verified")).
    Where(mysql.Quote("p", "verified").EQ(mysql.Arg(true)))

UPDATE users SET processed = ? 
WHERE processed = ? 
ORDER BY created_at ASC
LIMIT ?

mysql.Update("users").
    Set("processed", mysql.Arg(true)).
    Where(mysql.Quote("processed").EQ(mysql.Arg(false))).
    OrderBy(mysql.Quote("created_at").Asc()).
    Limit(100)

UPDATE products SET price = price * ?
WHERE category = ?

mysql.Update("products").
    Set("price", mysql.Quote("price").Mul(mysql.Arg(1.1))).
    Where(mysql.Quote("category").EQ(mysql.Arg("electronics")))

UPDATE users SET metadata = JSON_SET(metadata, '$.last_login', ?)
WHERE id = ?

mysql.Update("users").
    Set("metadata", mysql.F("JSON_SET", 
        mysql.Quote("metadata"), 
        mysql.Arg("$.last_login"), 
        mysql.Arg(time.Now()))).
    Where(mysql.Quote("id").EQ(mysql.Arg(1)))

UPDATE users SET status = 
    CASE 
        WHEN last_login > ? THEN 'active'
        WHEN last_login > ? THEN 'inactive'
        ELSE 'dormant'
    END

mysql.Update("users").
    Set("status", mysql.Case().
        When(mysql.Quote("last_login").GT(mysql.Arg(time.Now().AddDate(0, 0, -30))), mysql.Arg("active")).
        When(mysql.Quote("last_login").GT(mysql.Arg(time.Now().AddDate(0, -3, 0))), mysql.Arg("inactive")).
        Else(mysql.Arg("dormant")))