MySQL: return updated rows

Question

I am trying to combine these two queries in twisted python:

SELECT * FROM table WHERE group_id = 1013 and time > 100;

and:

UPDATE table SET time = 0 WHERE group_id = 1013 and time > 100

into a single query. Is it possible to do so?

I tried putting the SELECT in a sub query, but I don't think the whole query returns me what I want.

Is there a way to do this? (even better, without a sub query) Or do I just have to stick with two queries?

Thank You,

Quan

user_10312806 · Answer

This is really late to the party, but I had this same problem, and the solution I found most helpful was the following:

SET @uids := null;
UPDATE footable
   SET foo = 'bar'
 WHERE fooid > 5
   AND ( SELECT @uids := CONCAT_WS(',', fooid, @uids) );
SELECT @uids;

user_5959863 · Answer

UPDATE tab SET column=value RETURNING column1,column2...