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 colum

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

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 keywords_trans