A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
need MYSQL searching help
Joined: Oct 10, 2004
Oct 12, 2004 23:17:00
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 ]
Joined: Aug 15, 2004
Oct 13, 2004 00:09:00
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.
It is sorta covered in the
JavaRanch Style Guide
subject: need MYSQL searching help
==> need search algorithm help
SCEA II/III passed with 92%
search algorithm help
Database connectivity problem
Storing a password to encrypt/decrypt sensitive data.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013