Group items tagged

SQL Criteria WHERE column = value ->add(column, value); WHERE column <> value ->add(column, value, Criteria::NOT_EQUAL); Other Comparison Operators > , < Criteria::GREATER_THAN, Criteria::LESS_THAN >=, <= Criteria::GREATER_EQUAL, Criteria::LESS_EQUAL IS NULL, IS NOT NULL Criteria::ISNULL, Criteria::ISNOTNULL LIKE, ILIKE Criteria::LIKE, Criteria::ILIKE IN, NOT IN Criteria::IN, Criteria::NOT_IN Other SQL Keywords ORDER BY column ASC ->addAscendingOrderByColumn(column); ORDER BY column DESC ->addDescendingOrderByColumn(column); LIMIT limit ->setLimit(limit) OFFSET offset ->setOffset(offset) FROM table1, table2 WHERE table1.col1 = table2.col2 ->addJoin(col1, col2) FROM table1 LEFT JOIN table2 ON table1.col1 = table2.col2 ->addJoin(col1, col2, Criteria::LEFT_JOIN) FROM table1 RIGHT JOIN table2 ON table1.col1 = table2.col2 ->addJoin(col1, col2, Criteria::RIGHT_JOIN)