Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

In this Discussion

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.