[sqlite] An update with LIMIT ?

[Jay Macaulay]

Hi all,

I have a database where I'm selecting rows using LIMIT.  Is there a way I could use 
LIMIT in an update?  For example right now I do:

SELECT * FROM address WHERE group="a" LIMIT 5;  

Is there some way I could instantly update those 5 I retrieved?  Something like:

UPDATE address SET retrieved=1 WHERE group="a" LIMIT 5;  

So it only updates the same 5 I just selected?  I'm trying to select then marked as 
retrieved.  I don't think I can use LIMIT in an UPDATE statements.  

Any help would be appreciated,
Jay Macaulay