Problems with FullText

------=_NextPart_000_007A_01C322FA.4303D980
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi everybody,

Regards from Brazil

I've been working with MySQL since 1999 and I always by happy with the
results.

But now I'm trying to use the full text index and I've been having =
problems
with the "*" operator.

This just doesn=B4t work.

I've created a table with this script:

create table full
(id_full integer auto_increment primary key,
texto1 varchar(255),
texto2 longtext)

And the full text index with:

creste fulltext index i_full1 on full (texto1, texto2)

I put some records in the table with expressions:

"express"
"jornalexpress"
"expressjornal"

When I made a search like this:

select id_full, match(texto1, texto2) against('express') from full
where match(texto1, texto2) against('express');

everything works fine and just the lines with "express" has returned.

Then, I tried to do something like that:

select id_full, match(texto1, texto2) against('express*') from full
where match(texto1, texto2) against('express*');

and that:

select id_full, match(texto1, texto2) against('*express') from full
where match(texto1, texto2) against('*express');

But just the records with "express" returned. The line with =
expressjornal
has totaly ignored.

Then, I tried this:

select id_full, match(texto1, texto2) against('expres*') from full
where match(texto1, texto2) against('expres*');

And nothing has returned.

What's going on?

I used 2 different databases:

MySQL 3.23.52 in a RedHat 7.3 and
MySQL 4.0.11Gama in a Mandrake 9.1

The table was a test with just 100 records.

Thanks.


Emanuel




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.483 / Virus Database: 279 - Release Date: 19/5/2003
------=_NextPart_000_007A_01C322FA.4303D980--