Multiple result? MySQL

Question

I know how to get rows in MySQL, but what about if I have two rows with the same key and I want to get the two rows?

For example

"SELECT * FROM test WHERE (key_exaple = ?)"

The ps.setString(1, "test");

But let's imagine that I have two rows with the "test" key.

How can I get them one by one?

Answer 1

Assuming your 'ps.' stands for PreparedStatement, you can use:

SELECT * FROM test WHERE key_exaple in (?, ?)

ps.setString(1, "test");
ps.setString(2, "second test");

this might help