> 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 column. If your query searches in more than one column, you have to add a multicolumn index on all those columns. And also, the string (word) you are matching must be over 4 characters (maybe not on MySQL 4.x, but surely on MySQL 3) Regards, -- Andrei BEJENARU - Developer InterAKT Online http://www.interakt.ro/ Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
