SQLdriver: Update same column on multiple rows with different values

BleistivtBleistivt MVP
edited January 2015 in Development

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

Comments

Sign In or Register to comment.