SEO

#1 (**permalink**) 02-28-2008, 08:49 AM

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

#2 (**permalink**) 02-28-2008, 08:50 AM

'*' should be used after the word, like so...

+word1*

There is a variable in mysql to change the minimum length included in
full text search indexes. I can't remember it off hand.

Note. Your search word can be less than 3 characters if you use '*',
however it will only match words that end up being 3 or more
characters. e.g.

a*
this will match 'another', 'allow' but not 'an'

Tigger

Volare wrote:
> 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

some questions on FULL TEXT search