SQL exception when trying make an prepared statement

Question

I'm trying to pass the following String to a PreparedStatement:

private static final String QUICK_SEARCH = "select * from c where NAME like '% ? %'";

However, I get an SQL exception that the bind variable is missing.

Any suggestions?

Answer 1

You can't put binding variables inside a string like that.

You need to use:

SELECT * FROM c WHERE name LIKE CONCAT('%', ?, '%')

or similar, depending on what functions are supported by your version of SQL.

Answer 2

Can't u make use of parameters inside of using string concatenation ?

Answer 3

cool,

i just set the % signs when setting preparedstatement;

pstmt.setString(1, "%" + name + "%");