🚀 go-pugleaf

I would like to ask some hints about SEARCHING...
This is about Library Management System.

Let's say I have the following in titles in the database:

1 "The PowerBuilder for DOS"
2 "An Introduction to Database and SQL"
3 "Advance Newbie"
4 "Accelerate into C++ Programming"
5 "C++ for Dummies"

When the user search for:

"PowerBuilder"   Displays(1)
"SQ"             No result
"SQL"            Displays(2)
"C++"            Displays(4,5)

(Also I will be filtering : A, An, The, Is, For, blah blah.. To get
 only the root word)

I don't think I can achive this with that set of data. I'm planing to
add another table to store the choped version of the title.

Something like this:

1:PowerBuuilder
1:Dos
2:Introduction
2:Database
2:SQL
3:Advance
3:Newbie
4:Accelerate
4:C++
4:Programming
5:C++
5:Dummies

With this I can do an IN clause or a series of AND blah.. AND blah...

Is this OK?? Or I'm getting into confusion. Please put me into
the right path... Or maybe give me some link about this topic.

Thank you very much.

(please respond by e-mail)

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own