Using “like” wildcard in prepared statement

by

You need to set it in the value itself, not in the prepared statement SQL string.

So, this should do for a prefix-match:

notes = notes
    .replace("!", "!!")
    .replace("%", "!%")
    .replace("_", "!_")
    .replace("[", "![");
PreparedStatement pstmt = con.prepareStatement(
        "SELECT * FROM analysis WHERE notes LIKE ? ESCAPE '!'");
pstmt.setString(1, notes + "%");

or a suffix-match:

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

or a global match:

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

More Related Contents:

  1. Java: Insert multiple rows into MySQL with PreparedStatement
  2. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  3. right syntax to use near ‘?’
  4. mysql prepared statement error: MySQLSyntaxErrorException
  5. How to use prepared statement for select query in Java?
  6. PreparedStatement IN clause alternatives?
  7. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  8. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  9. How can I get the SQL of a PreparedStatement?
  10. Can we connect remote MySQL database in Android using JDBC? [closed]
  11. Android JDBC not working: ClassNotFoundException on driver
  12. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  13. Variable column names using prepared statements
  14. Where’s my invalid character (ORA-00911)
  15. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  16. JDBC MySql connection pooling practices to avoid exhausted connection pool
  17. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  18. Running a .sql script using MySQL with JDBC
  19. How does Java’s PreparedStatement work?
  20. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  21. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  22. JDBC character encoding
  23. how to get list of Databases “Schema” names of MySql using java JDBC
  24. Access denied for user ‘root’@’localhost’
  25. Is there a way to retrieve the autoincrement ID from a prepared statement
  26. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  27. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  28. JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?
  29. PreparedStatement and setTimestamp in oracle jdbc
  30. java.sql.SQLException: No database selected – why?

Leave a Comment