filterWhere() public method
Sets the WHERE part of the query but ignores empty operands. This method is similar to where(). The main difference is that this method will remove empty query operands. As a result, this method is best suited for building query conditions based on filter values entered by users. The following code shows the difference between this method and where(): // WHERE `age`=:age
$query->filterWhere(['name' => null, 'age' => 20]);
// WHERE `age`=:age
$query->w