/** * Add criteria as HAVING expression to query statement. * @see Query::where() * * @param mixed $column Expression, column name, column number, expression with placeholders or array(column=>value, ...) * @param mixed $value Value or array of values * @param int $flag Query::REPLACE, Query::PREPEND or Query::APPEND + Query::BACKQUOTE_% * @return Query $this */ public function having($column, $value = null, $flags = 0) { $where = QuerySplitter::buildWhere($column, $value, $flags); if (isset($where)) { $this->setPart('having', $where, $flags); } return $this; }
public function testBuildWhere_TwoParamsArray() { $where = QuerySplitter::buildWhere('foo IN ? AND bar LIKE %?%', array(array(10, 20), "blue")); $this->assertEquals('`foo` IN (10, 20) AND `bar` LIKE "%blue%"', $where); }