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
PDO is not good with such things. You need to create a string with placeholders dynamically and insert it into the query, while binding array values the usual way. With positional placeholders it would be like this: $in = str_repeat(‘?,’, count($in_array) – 1) . ‘?’; $sql = “SELECT * FROM my_table WHERE my_value IN ($in)”; … Read more