w10schools
Login Register
  • Home
  • Tutorials
    • HTML, CSS
      • HTML, HTML5
      • CSS, CSS3
    • XML
    • JavaScript, AJAX
    • PHP
    • Ruby on Rails
      • Ruby
      • Rails
    • ASP.NET
      • ASP
      • C# .NET
    • Java
      • JSP
    • Databases
      • MySQL
      • MSSQL Server
      • Oracle
    • Web Server
      • Windows
      • Linux
      • Apache
      • IIS
    • Design
      • Dreamweaver
      • Flash
      • Photoshop
      • Fireworks
      • CorelDRAW
      • Illustrator
  • References
    • HTML
      • Bootstrap
    • CSS
      • CSS Selectors
      • Sass
    • JavaScript
    • Mobile Apps
      • Cordova
    • Ruby on Rails
      • Ruby
      • Rails
    • PHP
      • Function
      • Language
      • CodeIgniter
      • Phalcon
      • PHPUnit
      • Symfony
      • Drupal
      • Yii
      • Laravel
    • Perl
      • Perl
    • Python
      • Python
      • Django
      • NumPy
      • Pandas
      • scikit-image
      • scikit-learn
      • Statsmodels
      • Matplotlib
    • Lua
      • Lua
    • C, C++
      • C
      • C++
    • Server
      • Docker
      • Apache HTTP Server
      • Nginx
    • Database
      • PostgreSQL
    • Big Data
      • TensorFlow
    • Game Development
      • Phaser
      • LÖVE
  • Articles
    • News
    • General
      • Website Promotion
      • Online Advertising
      • Make Money Online
    • Editorials
    • Interviews
    • Web Roundups
  • Resources
    • Design
      • Fonts
      • Graphics
      • Vectors
      • Templates
      • UI (User Interface)
      • Brushes
      • Patterns, Backgrounds
      • Textures
    • Web Development
      • HTML, CSS
      • XML
      • JavaScript, AJAX
      • Ruby on Rails
      • PHP
      • Java
      • .NET
      • Python
      • Perl
      • Flash
    • Mobile Application Development
      • Mobile Development Tools
      • Swift
    • Online Services
      • Online Storage
      • Web Hosting
  • Tools
    • Generators
Edit
In Place Editing Advanced Editing
  • References
  • PHP
  • Yii
  • db
  • QueryTrait

db\QueryTrait where()

where() public method

Sets the WHERE part of the query.

See yii\db\QueryInterface::where() for detailed documentation.

See also:

  • andWhere()
  • orWhere()
public $this where ( $condition )
$condition string|array

The conditions that should be put in the WHERE part.

return $this

The query object itself

Links:
  • http://www.yiiframework.com/doc-2.0/yii-db-querytrait.html#where()-detail
doc_Yii
doc_Yii
2025-01-10 15:47:30
Comments
Leave a Comment

Please login to continue.

Popular Articles
db\QueryTrait $where $where public property Query condition. This refers to the WHERE clause in a SQL statement. For example, ['age' => 31, 'team' => 1]. See al
db\QueryTrait $indexBy $indexBy public property The name of the column by which the query results should be indexed by. This can also be a callable (e.g. anonymous func
db\QueryTrait offset() offset() public method Sets the OFFSET part of the query. public $this offset ( $offset )$offset integer The offset. Use null or negative valu
db\QueryTrait andFilterWhere() andFilterWhere() public method Adds an additional WHERE condition to the existing one but ignores empty operands. The new condition and the exist
db\QueryTrait $orderBy $orderBy public property How to sort the query results. This is used to construct the ORDER BY clause in a SQL statement. The array keys are the


Return to View
  • Facebook
  • Tweet
  • Digg it
  • Stumbleupon
  • Delicious
  • Plus Share

Designed by : w10schools

service@w10schools.com

Our Partners: aeeble – Providing content publishing and search solutions