On 7 Jul 2018, at 12:04pm, Cecil Westerhof <cldwester...@gmail.com> wrote:

> ‚ÄčI went for the following solution:
>    UPDATE selectRandom
>    SET    lastUsed    = DATE('now', 'localtime')
>    ,      lastUsedIdx = (
>        SELECT IFNULL(MAX(lastUsedIdx), 0)
>        FROM   selectRandom
>        WHERE  lastUsed = DATE('now', 'localtime')
>    ) + 1
>    WHERE  description = :teaToBrew
> 
> I would think that is not to convoluted.

Elegant.  I understood it.  Though I was primed with what you're trying to do.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to