DQL (Doctrine Query Language) - WHERE clause.php 554 Bytes
Newer Older
zYne's avatar
zYne committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Syntax:
<div class='sql'>
<pre>
WHERE <i>where_condition</i>
</pre>
</div>
<ul>
<li \> The WHERE clause, if given, indicates the condition or conditions that the records must satisfy to be selected.
<br \><br \>
<li \> <i>where_condition</i> is an expression that evaluates to true for each row to be selected. 
<br \><br \>
<li \> The statement selects all rows if there is no WHERE clause.
<br \><br \>
<li \> When narrowing results with aggregate function values HAVING clause should be used instead of WHERE clause
<br \><br \>
</ul>