> As of Version 4.0.1, MySQL can also perform boolean full-text searches I am running Mysql 3.x . This sounds like a simple task to me. Is it not implemented in 3.x? It does not have to be OR, NOR or anything, just AND merlin "Larry E . Ullman" <LarryUllman@DMCInsights.Com> schrieb im Newsbeitrag ED63D76E-CB57-11D7-8CA0-000393641AFC@DMCInsights.Com">news:ED63D76E-CB57-11D7-8CA0-000393641AFC@DMCInsights.Com... > > I do get results for islands in greece as well. How can I specify in my > > statement, that both words have to be present? > > From the MySQL manual: > As of Version 4.0.1, MySQL can also perform boolean full-text searches > using the IN BOOLEAN MODE modifier. > > mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+MySQL > -YourSQL' IN BOOLEAN MODE); > > Use + to indicate required words. > > Larry > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
