Problems with boolean keyword search

2004-06-17 Thread Andreas Ahlenstorf
Hello, I have to build a keyword search with support for the boolean operators +, -, * and . Basically it's quite easy: Connect the three tables with two joins, keyword search with LIKE. But the boolean operators give me a headache. mysql SELECT c.id FROM keywords AS a LEFT JOIN

Re: Problems with boolean keyword search

2004-06-17 Thread Eamon Daly
: Andreas Ahlenstorf [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:40 AM Subject: Problems with boolean keyword search Hello, I have to build a keyword search with support for the boolean operators +, -, * and . Basically it's quite easy: Connect the three tables

Re: Problems with boolean keyword search

2004-06-17 Thread Andreas Ahlenstorf
Hello, Eamon Daly schrieb am Donnerstag, 17. Juni 2004 um 19:04: FYI, MySQL allows boolean searching as of 4.0.1. See: http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html I normally use that. But: Very bad result quality because there are only sigle keywords. I tried it with a text column