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!

Aaron · Accepted Answer · 2009-10-09 15:26:15Z

2

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

answered Oct 9, 2009 at 15:26

Aaron

3822 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

joeni · Accepted Answer · 2009-12-22 11:10:55Z

1

Close the against:

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

answered Dec 22, 2009 at 11:10

joeni

111 bronze badge