Skip to main content

Home/ foograde/ Group items tagged sentencias sql

Rss Feed Group items tagged

Adán Muguiro

The Definitive Guide to symfony | Chapter 8 - Inside The Model Layer | symfony | Web PH... - 0 views

  • 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)
  •  
    Sentencias SQL y sus equivalentes con Criteria
1 - 1 of 1
Showing 20 items per page