SQLdriver: Update same column on multiple rows with different values

Maybe I have overlooked something, but is it possible to build a query that updates the same column over multiple rows with different values using the query builder?

e.g. if I wanted to update the discussion count of users 2,7,8 who have the discussion counts 50, 600, 70

[
    2 => 50,
    7 => 600,
    8 => 70
]

My themes: pure | minusbaseline - My plugins: CSSedit | HTMLedit | InfiniteScroll | BirthdayModule | [all] - PM me about customizations

  • Vanilla APP » Learn more «
  • iOS & Android App for Vanilla - White label app for your forum

Comments

Sign In or Register to comment.