Re: [fw-general] LIKE query in Zend_Db_Table_Select

[Nick Pack]

$select = $table->select()->where('field LIKE ?','%keywords%');
$table->fetchAll($select);

Not tested, but that should do it

Simon R Jones wrote:

hi

Is it possible to do a: SELECT * FROM users WHERE name LIKE '%keywords%'

style query via Zend_Db_Table_Select? I'm trying to write a simple search to return Zend_Db_Table_Rowset results.

best wishes,
Simon