building-queries.md

Building queries

To build a Yiisoft\Db\Query\Query object, you call various query building methods to specify different parts of a SQL query.

The names of these methods resemble the SQL keywords used in the corresponding parts of the SQL statement. For example, to specify the FROM part of a SQL query, you would call the Yiisoft\Db\Query\Query::from() method. All the query building methods return the query object itself, which allows you to chain many calls together.

• Select
• From
• Where
  • String format
  • Hash format
  • Operator format
    • and
    • or
    • not
    • between
    • not between
    • in
    • not in
    • like
    • or like
    • not like
    • or not like
    • exists
    • not exists
    • comparison
  • Object format
  • Appending conditions
  • Filter conditions
• OrderBy
• GroupBy
• Having
• Limit and Offset
• Join
• Union
• WithQuery