On 8 Jul 2018, at 9:40am, Simon Slavin <slav...@bigfraud.org> wrote:
> Use the conventional
>
> CAST(RANDOM() * 7) AS INTEGER
>
> or whatever spread you want.
Apologies. In SQLite this should be
(RANDOM() % 7)
instead. The percent sign is a 'modulo' operator.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
