Out of curiosity, where's the guarantee that the OK won't be displayed if an email is found? Do all unions show up in the return result based on where in the query they're called?
On Wed, May 16, 2018 at 6:25 AM, Clemens Ladisch <[email protected]> wrote: > > SELECT action FROM blocked WHERE email = ? > UNION ALL > SELECT 'OK' > LIMIT 1; > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
