Problems with fulltext

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´t 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


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Problems with fulltext

Hi,

Try to use % instead of * - the % have worked for me.

Best regards
Peter
Copenhagen, Denmark



----- Original Message -----
From: "Emanuel Alexandre Tavares"
To:
Sent: Monday, May 26, 2003 12:57 AM
Subject: Problems with fulltext


> 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´t 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
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=pwr@post4.tele.dk
>
>


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Problems with fulltext

Hi Peter,

Thanks for your help, but it was my first try.

I don't know.

It's possible that is there some mistake in my my.cnf?

[]'s


Emanuel
São Paulo - Brasil
www.connix.com.br
www.jornalexpress.com.br
www.paginasdinamicas.com.br



----- Original Message -----
From: "PeterWR"
To: "Emanuel Alexandre Tavares" ;

Sent: Sunday, May 25, 2003 9:41 PM
Subject: Re: Problems with fulltext


> Hi,
>
> Try to use % instead of * - the % have worked for me.
>
> Best regards
> Peter
> Copenhagen, Denmark
>
>
>
> ----- Original Message -----
> From: "Emanuel Alexandre Tavares"
> To:
> Sent: Monday, May 26, 2003 12:57 AM
> Subject: Problems with fulltext
>
>
> > 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´t 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
> >
> >
> > --
> > MySQL Bugs Mailing List
> > For list archives: http://lists.mysql.com/bugs
> > To unsubscribe: http://lists.mysql.com/bugs?unsub=pwr@post4.tele.dk
> >
> >
>
>


---
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


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Problems with fulltext

Hi,

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

The "*" operator only works in the boolean mode full-text search, which is
available in 4.0 and later. Also, the "*" only works in the end of the word=
..

> Then, I tried to do something like that:
>=20
> select id_full, match(texto1, texto2) against('express*') from full
> where match(texto1, texto2) against('express*');

This will work in 4.0 as:

SELECT ... FROM full WHERE
match(texto1, texto2) against('+express*' in boolean mode);

> and that:
>=20
> select id_full, match(texto1, texto2) against('*express') from full
> where match(texto1, texto2) against('*express');

This is unfortunately not possible.


Rgds,
Indrek

--=20
Are you MySQL certified? - http://www.mysql.com/certification/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy
/_/ /_/\_, /___/\___\_\___/ Uuem=F5isa, Haapsalu, Estonia
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org