File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes wildcard search Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "wildcard search" Watch "wildcard search" New topic

wildcard search

Vaibhav Chauhan
Ranch Hand

Joined: Aug 16, 2006
Posts: 115
please tell me how to to wildcard search using prepared statement .....what should be the query as ? looks for exact match of the word.....

please help me in this regard.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Include the wildcard parameter in your bind variable. i.e.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: wildcard search
Similar Threads
? wildcard in a method declaration
Tiger objectives - take 2
Too many search criteria?
WildCard Search using auto complete text box
implementing Wild Card search using struts textbox or autocomplete