Re: [PHP] need help with MySQL full text searching!!!!

2003-07-22 Thread Andrei BEJENARU
> I think you need to make a second index that just consists of the one column > > ALTER TABLE biblio ADD FULLTEXT (title) > > if you want to search on just that one column. > > ---John Holmes... Exactly! If you want to do a fultext search on a single column you must have a fulltext index on that

Re: [PHP] need help with MySQL full text searching!!!!

2003-07-21 Thread CPT John W. Holmes
CTED]> Sent: Monday, July 21, 2003 12:09 PM Subject: [PHP] need help with MySQL full text searching Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have been fulltext indexes like this: ALTER TABLE biblio ADD FULLTEXT (title,abstract); that w

[PHP] need help with MySQL full text searching!!!!

2003-07-21 Thread Angelo Zanetti
Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have been fulltext indexes like this: ALTER TABLE biblio ADD FULLTEXT (title,abstract); that worked fine, however my problem is whenever I want to do a select statement only comparing 1 of the columns