在Zend Framework 2中使用MySQL Case语句

Question

I need to use CASE in my Zend Db Statemets, which looks like following:

SELECT WHERE
   CASE 
      WHEN classified_fields_values.field_id = array(5, 6, 7) THEN classified_fields_values.value >= $min_value 
      WHEN classified_fields_values.field_id = 1 THEN classified_fields_values.value = $other_value  
END .

Tried with query() but Zend doesn't recognize it as a function.

Below is Zend Statement, in $select are all necessary configurations. I know it doesn't work as it should, put there for example.

$select
    ->joinRight('...', null)
    ->joinLeft('...', null)
    ->where('classified_fields_values.field_id IN (?)', $_array)
    ->where('classified_fields_values.value >= ?', $min_value)
    ->where('classified_fields_values.field_id = 8')
    ->where('classified_fields_values.value = ?', $other_value)

Any ideas how to implement CASE in Zend Query or how to do such a query would be helpfull.

Answer 1

Zend_Db_Expr

Try:

'final' => new Zend_Db_Expr("CASE classified_fields_values.alias WHEN classified_fields_values.field_id = array(5, 6, 7) THEN classified_fields_values.value >= $min_value")