> > Is there a way I could use LIMIT in an update?
>
> No, but if your table has a single-column primary key,
> called PK for example, you can get the same result with
>
> update Address set Retrieved = 1
> where PK in (select PK from Address
> where Group = 'a' limit 5)
Would you not need to do:
update Address set Retrieved = 1
where PK in (select PK from Address
where Group = 'a' and retrieved is null limit 5)
or something similar?
Unless I've misunderstood the intent of this query, the original poster
wanted to update each row as it had been retrieved to avoid retrieving it
again.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
