On a site I'm developing I need to conduct boolean searches. I use a
piece of code I found on:


and I've got to say it works really well.

The problem is I cannot search for one specific word because, even
though the word exists on several records, MySQL never returns any

The word I can't look for is "portaria". Any other word works just
fine. I have tried every word I could think of and it works... except
for that one: "portaria".

Here is the syntax:

SELECT *, match (titulo,estado,sumario,categoria,tipo,pachave)
against (' portaria ') as relevance FROM dgf_net.dgf_lex WHERE match
(titulo,estado,sumario,categoria,tipo,pachave) against ('portaria')>0
HAVING relevance>0 ORDER BY relevance DESC

And here is a view of the table:

Field Type Attributes Null Default Extra
id  int(11)   No    auto_increment
insdata  datetime   No  0000-00-00 00:00:00
startdata  datetime   No  0000-00-00 00:00:00
area  tinytext   No
autor  varchar(255)   No
titulo  varchar(255)   No
subtitulo  varchar(255)   No
texto  text   No
anexo  tinytext   No
pachave  varchar(255)   No
obs  tinytext   No
activo  char(1)   No  N
validade  datetime   No  0000-00-00 00:00:00
imagem  varchar(255)   No
cafe  varchar(8)   No

Indexes :
Keyname Type Cardinality Field
id  INDEX  None  id
titulo  FULLTEXT  None  titulo
texto  1

I'm puzzled! Why is MySQL picky about this specific word?
MySQL is 3.23.36 and PHP 4.0.4pl1

Any help is appreciated! :-)


:: cdb.pnorte.pt :: #26527125 ::
:: 02-14-2002 21:12:07 ::
:: A beer doesn't mind when your mother visits.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to