Re: [PHP-DB] full text search in mysql

2003-08-14 Thread Larry E . Ullman
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 I've never tried it, but you might be able to get away with SELECT columns FROM

Re: [PHP-DB] full text search in mysql

2003-08-14 Thread Larry E . Ullman
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

Re: [PHP-DB] full text search in mysql

2003-08-14 Thread Merlin
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 [EMAIL PROTECTED] schrieb im Newsbeitrag

[PHP-DB] full text search in mysql

2003-08-14 Thread Merlin
Hi fellowes, I am working on a full text search in php and mysql. It workes pretty good, with one exception. If two words are entered, I do get results for each words in seperate as well. Examle: carribean islands I do get results for islands in greece as well. How can I specify in my

[PHP-DB] Full text search of mysql

2003-02-12 Thread Hardik Doshi
Hello, I want to use mysql's full text search capabilities with two different tables. Can i join tables using full text search? I am using mysql 3.23.55 thanks Hardik __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day