Database Answers Logo
A Database for a Search Engine

The Search could be done by splitting up the Search into separate words ('tokens'), and
then returning the results with the highest being the ones with the most matches.

The basic SQL would look something like this :-
SELECT url_id,COUNT(*)
FROM url_key_word_matches
WHERE key_word LIKE 'Key Word in Search%'
GROUP BY url_id;
A Database for a Search Engine (7K)

[ Home Page | Ask me a Question | Email Us | FAQs | History of Databases | Useful Links ]

© IceBreaker WebDesigns 2000