An in statement will be parsed identically to field=val1 or field=val2 or field=val3. Putting a null in there will boil down to field=null which won’t work. (Comment by Marc B) I would do this for clairity SELECT * FROM tbl_name WHERE (id_field IN (‘value1’, ‘value2’, ‘value3’) OR id_field IS NULL)
Put the values in a temporary table and then do a select where id in (select id from temptable)
What I do is to add a “?” for each possible value. var stmt = String.format(“select * from test where field in (%s)”, values.stream() .map(v -> “?”) .collect(Collectors.joining(“, “))); Alternative using StringBuilder (which was the original answer 10+ years ago) List values = … StringBuilder builder = new StringBuilder(); for( int i = 0 ; … Read more
You need to turn it on its head in terms of the way you’re thinking about it. Instead of doing “in” to find the current item’s user rights in a predefined set of applicable user rights, you’re asking a predefined set of user rights if it contains the current item’s applicable value. This is exactly … Read more
How about session.query(MyUserClass).filter(MyUserClass.id.in_((123,456))).all() edit: Without the ORM, it would be session.execute( select( [MyUserTable.c.id, MyUserTable.c.name], MyUserTable.c.id.in_((123, 456)) ) ).fetchall() select() takes two parameters, the first one is a list of fields to retrieve, the second one is the where condition. You can access all fields on a table object via the c (or columns) property.
An analysis of the various options available, and the pros and cons of each is available in Jeanne Boyarsky’s Batching Select Statements in JDBC entry on JavaRanch Journal. The suggested options are: Prepare SELECT my_column FROM my_table WHERE search_column = ?, execute it for each value and UNION the results client-side. Requires only one prepared … Read more