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 <clem...@ladisch.de> wrote: > > SELECT action FROM blocked WHERE email = ? > UNION ALL > SELECT 'OK' > LIMIT 1; > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users