SUBSTRING() / MID() Statement in Zend Framework 2

Question

I'm trying to implement the following, pretty simple, query:

WHERE
  a.first_table IS NULL
  AND a.second_table IS NOT NULL
  AND SUBSTRING(b.third_table,5,2) = @plan_year;

As you might guess the first two statements are not really a problem. I currently fail at implementing the SUBSTRING() via Zend, as I want to keep the code DB-System neutral. Is there any way to do this ?

Thanks

Answer 1

What about to use SUBSTR instead of SUBSTRING?

WHERE
  a.first_table IS NULL
  AND a.second_table IS NOT NULL
  AND SUBSTR(b.third_table,5,2) = @plan_year;