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