Zend_Db_Select LIKE clause

Question

How can I set this query

SELECT city_id FROM cities WHERE city_name LIKE "%Vicenza%"

using the Zend_Db_Select class?

score 10 · Answer 1 · answered Nov 15 '12 at 16:20

10

Since @Jerec's answer didn't mention it... in order to have the effect of:

LIKE '%{$searchTerm}%'

You'll need to add the extra modifiers to the variable like such:

// Correct way
->where("city_name LIKE ?", "%{$searchTerm}%")

// Wrong ways
->where("city_name LIKE %?%", $searchTerm)
->where("city_name LIKE '%?%'", $searchTerm)

Might seem obvious, but took me three attempts to get it right.

answered Nov 15 '12 at 16:20

rodrigo-silveira

12,607
11
69
123

1

Thank you Rodrigo! Your answer just saved my time! – Roger Mar 15 '13 at 14:55

Jerec TheSith · Answer 2 · 2011-08-09T12:09:52.907

2

You could use this method

   $select = $dbTable->select()
    ->from('cities', 'city_id')
    ->where('city_name LIKE ?', $searchTerm);

where $dbTable is an instance of an Zend_Db_Table class

edited Aug 09 '11 at 12:09

answered Aug 09 '11 at 10:20

Jerec TheSith

1,932
4
32
41

Thanks :) What the **setIntegrityCheck** method does exactly? – Egidio Caprino Aug 09 '11 at 11:45
`setIntegrityCheck` allows `Zend_Db_Table_Select` to select rows outside of it's initial table, so you don't need it at all :) – Jerec TheSith Aug 09 '11 at 12:09

Zend_Db_Select LIKE clause

2 Answers2