From: "Gabriel PREDA" <[EMAIL PROTECTED]>
You ought to use the *Boolean Full-Text Searches.*
You would then do a:
SELECT title, Comment FROM table_name WHERE MATCH (Comment) AGAINST ('+foo
+bar' IN BOOLEAN MODE);
This way the rows that contain both words have higher relevance... those
that have
You ought to use the *Boolean Full-Text Searches.*
You would then do a:
SELECT title, Comment FROM table_name WHERE MATCH (Comment) AGAINST ('+foo
+bar' IN BOOLEAN MODE);
This way the rows that contain both words have higher relevance... those
that have only one... will have lower relevance.
Or
Using the full text function to run a search stunt on a table. all seem
working fine except im looking for ways to fine tune the table relevance. i
found out that the function relevates a row higer by the number of keywords
found in it and not by if all keywords is present in the row...
for instanc
