Rob Willett wrote: > select CASE > WHEN EXISTS (select 1 from blocked where email = > '[email protected]') > THEN (select action from blocked where email = > '[email protected]') > ELSE 'OK' > END
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
