$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

*/