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 that 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 greetings from Italy.

Maurizio