Hi!
The Task:
Different pieces of information are stored in a db, one of the fields of the table contains 3 keywords for each entry.
Now, when a user retreives a piece of information, at the end of it (eg. an article) it should display a link to "similar" entries in the db ie. where at least one of the keywords associated with the text also appears in the keyword field of the text to be linked to.
Is there a neat way to search the db for matches with ANY of the given keywords?
I guess I could find a way by producing a rather complicated query, searching the db first for one of the keywords, then for the second etc...then sorting out double or triple matches because 2 or 3 of the keywords matched...
Any help appreciated
Johannes
The Task:
Different pieces of information are stored in a db, one of the fields of the table contains 3 keywords for each entry.
Now, when a user retreives a piece of information, at the end of it (eg. an article) it should display a link to "similar" entries in the db ie. where at least one of the keywords associated with the text also appears in the keyword field of the text to be linked to.
Is there a neat way to search the db for matches with ANY of the given keywords?
I guess I could find a way by producing a rather complicated query, searching the db first for one of the keywords, then for the second etc...then sorting out double or triple matches because 2 or 3 of the keywords matched...
Any help appreciated
Johannes