How to write Zend db select with OR condition inside AND condition

zend-framework

Solution

If you wanted

SELECT `tbl_md_users`.* 
FROM `tbl_md_users` 
WHERE 
  user_type <> 'TYPE1')
AND (first_name LIKE '%tom%' OR first_name LIKE '%dick%' OR first_name LIKE '%harry%')

then the first answer doesn't work

I used Zend_Db_Expr instead

$likeTom = new Zend_Db_Expr("first_name LIKE '%tom%'");
$likeDick = new Zend_Db_Expr("first_name LIKE '%dick%'");
$likeHarry = new Zend_Db_Expr("first_name LIKE '%harry%'");

$query = $database->select ()
    ->from ('tbl_md_users')
    ->where ('user_type <> ?', 'TYPE1')
    ->where ("{$likeTom} OR {$likeDick} OR {$likeHarry}");

Problem

Can someone guide me to write a query like below using Zend db select : ``` SELECT `tbl_md_users`.* FROM `tbl_md_users` WHERE user_type <> 'TYPE1') AND (first_name LIKE '%tom%' OR last_name LIKE '%tom%' OR user_name LIKE '%tom%') ```

Original source