File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes need MYSQL searching help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "need MYSQL searching help" Watch "need MYSQL searching help" New topic
Author

need MYSQL searching help

Frank king
Greenhorn

Joined: Oct 10, 2004
Posts: 10
I have a database build by MYSQL includes list of book names and price.

when key in a book name, system will return it selling price.

however, if user keyed in name wrongly, for exmaple. "risl management" instead of real name "risk management", my system won't know how to handle this type of problem.

another problem is : if user doesn't key in the full name of the book, how the system could know which book the user is looking fot?

can any predefined searching method in MYSQL help me or any search algorithm can solve this kinds of problems??

thanks, waiting for your help asap.
[ October 13, 2004: Message edited by: Bear Bibeault ]
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
you can use "like" operator, if it is there in MySql.
else if it is really something about natural language processing so better go for some related algorithms.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: need MYSQL searching help