I want to update multiple rows in one query  , for example like this:

db_query("update bestsellers set count = 4 where product_id = 30;update bestsellers set count = 5 where product_id = 32;update bestsellers set count = 1 where product_id = 34;")->execute();

But server returns 500 error. I think it doesn't work , server can't process .

I want to update multiple rows in one query, for example as with the following code.

db_query("update bestsellers set count = 4 where product_id = 30; update bestsellers set count = 5 where product_id = 32; update bestsellers set count = 1 where product_id = 34;")->execute();

The server returns a 500 error. Is there any way to achieve this?