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

Vanilla 2.6 is here! It includes security fixes and requires PHP 7.0. We have therefore ALSO released Vanilla 2.5.2 with security patches if you are still on PHP 5.6 to give you additional time to upgrade.

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


Sign In or Register to comment.