On 17 September 2012 17:23, E. Timothy Uy wrote: > Is there a way to figure out which of the terms in an IN operator > actually hit? Perhaps making a temp table is the only way. Any help
Do you mean...
SELECT DISTINCT col FROM tbl WHERE col IN ('a', 'b', 'c', 'd');
Regards,
Paul.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

