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

Answer 1

Apparently mysql does have something that might be of use, especially if you are only updating one row.

This example is from: http://lists.mysql.com/mysql/219882

UPDATE mytable SET mycolumn = @mycolumn := mycolumn + 1 WHERE mykey = 'dante';  SELECT @mycolumn; 

I've never tried this though, but do let me know how you get on.