> 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)
If your primary key contains more than one column, you
can run the select first and use the results to compose
an update statement in your host language -- or you can
use RowID as a surrogate for PK in the first case (but
then your code won't be portable to any other dbms).
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
