Hi!
On a site I'm developing I need to conduct boolean searches. I use a
piece of code I found on:
http://www.evolt.org/article/comment/18/15665/http://www.evolt.org/art
icle/comment/18/15665/
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
rows.
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 for the query:
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 relevance0 ORDER BY relevance DESC
And here is a view of the table:
Field Type Attributes Null Default Extra
id int(11) Noauto_increment
estado varchar(255) Yes NULL
titulo varchar(255) Yes NULL
sumario text Yes NULL
url text Yes NULL
autor varchar(255) Yes NULL
insdata datetime Yes NULL
dipdata date Yes NULL
categoria varchar(255) Yes NULL
tipo varchar(255) Yes NULL
pachave varchar(255) Yes NULL
Indexes : Keyname Type Cardinality Field
PRIMARY PRIMARY 81 id
id UNIQUE 81 id
titulo FULLTEXT None titulo
estado
sumario 1
categoria
tipo
pachave
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! :-)
--
Joao Verde, [EMAIL PROTECTED] on 02/15/2002
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php