I have this list
<code>("item 1" , "item 2")
</code>
<code>("item 1" , "item 2")
</code>
("item 1" , "item 2")
This query
<code>SELECT * FROM table
WHERE SYSTEM in (?)
</code>
<code>SELECT * FROM table
WHERE SYSTEM in (?)
</code>
SELECT * FROM table
WHERE SYSTEM in (?)
The way I send and argument to ? is like this
<code>pstmt.setString(1,list)
</code>
<code>pstmt.setString(1,list)
</code>
pstmt.setString(1,list)
I have tried different ways to format the values inside the list to be in this format for the SQL query
<code>('item1' , 'item')
</code>
<code>('item1' , 'item')
</code>
('item1' , 'item')
But it never works because when I send over the argument I belive the whole string just gets put inside a ” “, which makes the comma, be inside the ” ” which is a problem.
Is there any way for me to use a list as an argument for a SQL query? thank you