Mark Maunder wrote: > I've started using > MySQL's MATCH/AGAINST with fulltext indexes instead, and it is extremelly > fast (!!), but am waiting for a feature that's available in mysql 4.0 (due > end of this month) that allows you to use +word and -word syntax to specify > required or unwanted keywords. Also just as an asside, match/against only > works with MyISAM tables so I've had to convert some of mine from InnoDB at > the cost of losing transactions.
er - lo and behold, mysql 4.0 alpha has been released a few minutes ago by Monty. http://www.mysql.com/downloads/mysql-4.0.html