updating multiple rows and another question

Is there a way to updateByPk more than one row at once obviously using different primary keys? I have a bunch of rows to update and don’t want to keep repeating updateByPk over and over. Can I combine the query somehow?

Also is there a way of doing something like "UPDATE some_row SET some_row = some_row + 1 WHERE … ?

Thanks in advance!!!

updateByPk() accepts an array of primary key values as its first parameter.


so it will be the same sql query applied to all the pk? can you have different query executed for each pk?

Perfect! Thank you.