consider this:
SELECT * FROM table_name WHERE column_name in(1,2,3) or column_name is
NULL
Here column name is referenced two times.
Putting it this way:
SELECT * FROM table_name WHERE column_name in(1,2,3,null)
causes that in() ignores null value without giving any error.
I need to add last part of this query to a function that must be column_name
agnostic, so that is a reason that otherwise simple workaround is out of
question here.
--
View this message in context:
http://old.nabble.com/How-to-search-for-multiple-values-in-a-column-including-null-without-repeating-column-name---tp31978469p31978469.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
