MySQL Forums
Forum List  »  Full-Text Search

some questions on FULL TEXT search
Posted by: Francesco Barilli
Date: December 26, 2006 05:25AM

Hi,
I'm programming the Search Engine for my website(php+mysql), I have a database with 5 tables and I'm using FULL TEXT search way:

$query="SELECT *, MATCH (filed1,field2,field3) AGAINST ('+word1 word2' IN BOOLEAN MODE) AS evidence FROM articles WHERE MATCH (filed1,field2,field3) AGAINST ('+word1 word2' IN BOOLEAN MODE) ORDER BY evidence DESC";

for each of the remaining 4 tables I have to rewrite the whole query or do you know a method to 'optimize' the 5 queries all in one?

About the AGAINST parameter if I wish to use '+' and '*' togheter for word1, what is the correct syntax:

+*word1?

A last question (have patience please) concerns those words of only 3 characters that are hidden by the FULL TEXT search. Is there a way to show forcedly them?

Excuse for my little english.
Thanks and regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
some questions on FULL TEXT search
3400
December 26, 2006 05:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.