String sql = "SELECT * FROM work.cs_book WHERE bookname = ? AND author = ? AND category = ?";
I have writtern above query and where i can search for a book based on bookname author and category. I am using preparedStatements to execute query.
However something is missing. How can i use wildcard search? like "Harry" search should also return "harry potter" book or "xxx harry yyy"
String sql = "SELECT * FROM work.cs_book WHERE bookname LIKE ? AND author LIKE ? AND category LIKE ?";
however its not working at all....
I am not sure. It's gonna dealt with java/sql!!