$products = Doctrine_Query::create() -> select("MATCH(name, shortinfo, description) AGAINST ('microsoft office') as score, p.*") -> from("Product p") -> where("WHERE MATCH(name, shortinfo, description) AGAINST ('microsoft office') IN BOOLEAN MODE)") -> orderBy("score") -> execute();/*Doctrine_Query_Exception: Unknown function MATCH.*/ $q = new Doctrine_RawSql(); $products = $q -> select("MATCH(p.name, p.shortinfo, p.description) AGAINST ('microsoft office' IN BOOLEAN MODE) as score, {p.*}") -> from("products p") -> where("WHERE MATCH(p.name, p.shortinfo, p.description) AGAINST ('microsoft office' IN BOOLEAN MODE)") -> orderBy("score") -> addComponent("p", "Product") -> execute(); /*Doctrine_Connection_Mysql_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE MATCH(p.name, p.shortinfo, p.description) AGAINST ('office' IN BOOLEAN MOD' at line 1*/