title: I want to insert a special character of SQL in JDBC
body: <p>I want to translate this Access sql query to Java JDBC</p>
  
  <p><code>Select *
  From books
  Where Lcase(title) LIKE Lcase('*jdbc*') AND Lcase(title) LIKE Lcase('*programming*')</code></p>
  
  <p>I use a preparedStatement like this</p>
  
  <pre><code>String sql1="Select * From books Where Lcase(title) LIKE Lcase(%?%) AND Lcase(title) LIKE Lcase(%?%)";
  PreparedStatement ps1=con.prepareStatement(sql1);
  ps1.setString(1, "jdbc");
  ps1.setString(2, "programming");
  ResultSet rs1=ps1.executeQuery();
  </code></pre>
  
  <p>But I get a syntax error</p>