SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Dec 19, 2002, 09:04 #1
- Join Date
- Jun 2000
- Posts
- 165
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
how to do relative (lateral) search
Hi there,
Does anybody out there know how to do a relative type lateral search like what occurs at altavista.com for example.
Basically, if someone types in a search term (like cars) I'd like to query a database of keywords that looks for related matches. e.g.
SELECT word FROM search_terms WHERE MATCH (word) AGAINST ('cars*' IN BOOLEAN MODE)
This will nicely deliver some related matches (e.g. rental cars, classic cars etc)
But, what about more lateral words (e.g. other modes of transport such as bikes or public transport).
Would this require a thesaraus or something?
Many thanks if you can assist.
Regards,
Jason
-
Dec 20, 2002, 06:56 #2
- Join Date
- Mar 2002
- Location
- Perth, Australia
- Posts
- 157
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Well, it would need a long table (or set of tables) with lots of many-to-many relationships associating each word with other words in the table. Which is basically a thesaurus. Perhaps there is one available to purchase, or, one day when you have some spare time ...
Paul Davey
webmaster for Whitford Church of Christ
Bookmarks