Criteria is a group of classes that allows you to build complex conditions for SQL queries using nice OO interface. The initial conception was adopted from Propel and later was a bit simplified.

}

All criteria classes are children of lmbSQLBaseCriteria class that implements basic functionality to allow a composition of criteria.

Criteria are commonly used with lmbSelectQuery class to insert conditions into %where% and %having% placeholders.

Here is how lmbSQLFieldCriteria is used:

$query->addCondition(newSQLFieldCriteria('name', '%'.$name.'%', lmbSQLFieldCriteria :: LIKE));

It's possible to combine criteria objects:

    $criteria = new lmbSQLTableFieldCriteria('ingredient.name', '%'.$name.'%', lmbSQLFieldCriteria :: LIKE);
    $new_criteria = new lmbSQLTableFieldCriteria('ingredient.name', '%'.$name.'%', lmbSQLFieldCriteria :: LIKE);
    $criteria->addOr($new_criteria);
    $criteria->addAnd(new SQLFielBetweenCriteria('value', 10, 20));
    $query->addCondition($criteria);