Zend Framework normal query to Zend_Db_Table

Question

Here is my query:

"SELECT * FROM `posts` WHERE MATCH(title, text) AGAINST('".$word."' IN BOOLEAN MODE)";

How can I do this with Zend_Db_Table, I mean($this->select()...)

Best Regards!

Answer 1

$dbTable = new Default_Model_DbTable_Posts();
$select = $dbTable->select()->where('MATCH(title, text) AGAINST(? IN BOOLEAN MODE', $word);

Answer 2

Close the against:

$dbTable = new Default_Model_DbTable_Posts();
$select = $dbTable->select()->where('MATCH(title, text) AGAINST(? IN BOOLEAN MODE)', $word);