Wildcards in Java PreparedStatements

Question

Here's my current SQL statement:

SEARCH_ALBUMS_SQL = "SELECT * FROM albums WHERE title LIKE ? OR artist LIKE ?;";

It's returning exact matches to the album or artist names, but not anything else. I can't use a '%' in the statement or I get errors.

How do I add wildcards to a prepared statement?

(I'm using Java5 and MySQL)

Thanks!

Answer 1

You put the % in the bound variable. So you do

   stmt.setString(1, "%" + title + "%");
   stmt.setString(2, "%" + artist + "%");