<html>
<head>
<title>Docs For Class QueryBuilder</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>
<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
<tr>
<td class="header_top">QueryBuilder</td>
</tr>
<tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
<tr>
<td class="header_menu">
[ <a href="../classtrees_QueryBuilder.html" class="menu">class tree: QueryBuilder</a> ]
[ <a href="../elementindex_QueryBuilder.html" class="menu">index: QueryBuilder</a> ]
[ <a href="../elementindex.html" class="menu">all elements</a> ]
</td>
</tr>
<tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="200" class="menu">
<b>Packages:</b><br />
<a href="../li_QueryBuilder.html">QueryBuilder</a><br />
<br /><br />
<b>Files:</b><br />
<div class="package">
<a href="../QueryBuilder/_QueryBuilder.php.html"> QueryBuilder.php
</a><br>
</div><br />
<b>Classes:</b><br />
<div class="package">
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a><br />
</div>
</td>
<td>
<table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">
<h1>Class: QueryBuilder</h1>
Source Location: /QueryBuilder.php<br /><br />
<table width="100%" border="0">
<tr><td valign="top">
<h3><a href="#class_details">Class Overview</a></h3>
<pre></pre><br />
<div class="description">A dead simple PHP 5 OO interface for building SQL queries. No manual string concatenation necessary.</div><br /><br />
<h4>Author(s):</h4>
<ul>
<li>Justin Stayton <<a href="mailto:hide@address.com">hide@address.com</a>></li>
</ul>
<h4>Version:</h4>
<ul>
<li>4.0.0</li>
</ul>
<h4>Copyright:</h4>
<ul>
<li>Copyright 2011-2012 by Justin Stayton</li>
</ul>
</td>
<td valign="top">
<h3><a href="#class_consts">Constants</a></h3>
<ul>
<li><a href="../QueryBuilder/QueryBuilder.html#constBETWEEN">BETWEEN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constBRACKET_CLOSE">BRACKET_CLOSE</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constBRACKET_OPEN">BRACKET_OPEN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constEQUALS">EQUALS</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constGREATER_THAN">GREATER_THAN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constGREATER_THAN_OR_EQUAL">GREATER_THAN_OR_EQUAL</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constIN">IN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constINNER_JOIN">INNER_JOIN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constIS">IS</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constIS_NOT">IS_NOT</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constLEFT_JOIN">LEFT_JOIN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constLESS_THAN">LESS_THAN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constLESS_THAN_OR_EQUAL">LESS_THAN_OR_EQUAL</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constLIKE">LIKE</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constLOGICAL_AND">LOGICAL_AND</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constLOGICAL_OR">LOGICAL_OR</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constNOT_BETWEEN">NOT_BETWEEN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constNOT_EQUALS">NOT_EQUALS</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constNOT_IN">NOT_IN</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constNOT_LIKE">NOT_LIKE</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constNOT_REGEX">NOT_REGEX</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constORDER_BY_ASC">ORDER_BY_ASC</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constORDER_BY_DESC">ORDER_BY_DESC</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constREGEX">REGEX</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#constRIGHT_JOIN">RIGHT_JOIN</a></li>
</ul>
</td>
<td valign="top">
<h3><a href="#class_methods">Methods</a></h3>
<ul>
<li><a href="../QueryBuilder/QueryBuilder.html#methodandHaving">andHaving</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodandWhere">andWhere</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#method__construct">__construct</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodcalcFoundRows">calcFoundRows</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodcloseHaving">closeHaving</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodcloseWhere">closeWhere</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methoddelete">delete</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methoddistinct">distinct</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodfrom">from</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetDeleteString">getDeleteString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetFrom">getFrom</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetFromAlias">getFromAlias</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetFromString">getFromString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetGroupByString">getGroupByString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetHavingPlaceholderValues">getHavingPlaceholderValues</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetHavingString">getHavingString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetInsert">getInsert</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetInsertString">getInsertString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetJoinString">getJoinString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetLimit">getLimit</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetLimitOffset">getLimitOffset</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetLimitString">getLimitString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetOptionsString">getOptionsString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetOrderByString">getOrderByString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetPdoConnection">getPdoConnection</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetPlaceholderValues">getPlaceholderValues</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetQueryString">getQueryString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetReplace">getReplace</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetReplaceString">getReplaceString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetSelectString">getSelectString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetSetPlaceholderValues">getSetPlaceholderValues</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetSetString">getSetString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetUpdate">getUpdate</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetUpdateString">getUpdateString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetWherePlaceholderValues">getWherePlaceholderValues</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgetWhereString">getWhereString</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodgroupBy">groupBy</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodhaving">having</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodhavingBetween">havingBetween</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodhavingIn">havingIn</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodhavingNotBetween">havingNotBetween</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodhavingNotIn">havingNotIn</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodinnerJoin">innerJoin</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodinsert">insert</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodisDelete">isDelete</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodisInsert">isInsert</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodisReplace">isReplace</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodisSelect">isSelect</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodisUpdate">isUpdate</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodjoin">join</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodleftJoin">leftJoin</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodlimit">limit</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeDeleteInto">mergeDeleteInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeFromInto">mergeFromInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeGroupByInto">mergeGroupByInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeHavingInto">mergeHavingInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeInsertInto">mergeInsertInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeInto">mergeInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeJoinInto">mergeJoinInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeLimitInto">mergeLimitInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeOptionsInto">mergeOptionsInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeOrderByInto">mergeOrderByInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeReplaceInto">mergeReplaceInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeSelectInto">mergeSelectInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeSetInto">mergeSetInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeUpdateInto">mergeUpdateInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodmergeWhereInto">mergeWhereInto</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodopenHaving">openHaving</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodopenWhere">openWhere</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodoption">option</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodorderBy">orderBy</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodorHaving">orHaving</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodorWhere">orWhere</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodquery">query</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodquote">quote</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodreplace">replace</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodrightJoin">rightJoin</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodselect">select</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodset">set</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodsetPdoConnection">setPdoConnection</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodupdate">update</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodwhere">where</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodwhereBetween">whereBetween</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodwhereIn">whereIn</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodwhereNotBetween">whereNotBetween</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#methodwhereNotIn">whereNotIn</a></li>
<li><a href="../QueryBuilder/QueryBuilder.html#method__toString">__toString</a></li>
</ul>
</td>
</tr></table>
<hr />
<table width="100%" border="0"><tr>
</tr></table>
<hr />
<a name="class_details"></a>
<h3>Class Details</h3>
<div class="tags">
[line 13]<br />
A dead simple PHP 5 OO interface for building SQL queries. No manual string concatenation necessary.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>author:</b> </td><td>Justin Stayton <<a href="mailto:hide@address.com">hide@address.com</a>></td>
</tr>
<tr>
<td><b>version:</b> </td><td>4.0.0</td>
</tr>
<tr>
<td><b>copyright:</b> </td><td>Copyright 2011-2012 by Justin Stayton</td>
</tr>
<tr>
<td><b>license:</b> </td><td><a href="http://en.wikipedia.org/wiki/MIT_License">MIT License</a></td>
</tr>
</table>
</div>
</div><br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<hr />
<a name="class_methods"></a>
<h3>Class Methods</h3>
<div class="tags">
<hr />
<a name="methodandHaving"></a>
<h3>method andHaving <span class="smalllinenumber">[line 1500]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> andHaving(
string
$column, mixed
$value, [string
$operator = self::EQUALS])</code>
</td></tr></table>
</td></tr></table><br />
Add an AND HAVING condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>colum name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$operator</b> </td>
<td>optional comparison operator, default =</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodandWhere"></a>
<h3>method andWhere <span class="smalllinenumber">[line 1290]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> andWhere(
string
$column, mixed
$value, [string
$operator = self::EQUALS])</code>
</td></tr></table>
</td></tr></table><br />
Add an AND WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>colum name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$operator</b> </td>
<td>optional comparison operator, default =</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="method__construct"></a>
<h3>constructor __construct <span class="smalllinenumber">[line 272]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> __construct(
[
$PdoConnection = null])</code>
</td></tr></table>
</td></tr></table><br />
Constructor.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">PDO|null </td>
<td><b>$PdoConnection</b> </td>
<td>optional PDO database connection</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodcalcFoundRows"></a>
<h3>method calcFoundRows <span class="smalllinenumber">[line 389]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> calcFoundRows(
)</code>
</td></tr></table>
</td></tr></table><br />
Add SQL_CALC_FOUND_ROWS execution option.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodcloseHaving"></a>
<h3>method closeHaving <span class="smalllinenumber">[line 1475]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> closeHaving(
)</code>
</td></tr></table>
</td></tr></table><br />
Add a closing bracket for nesting HAVING conditions.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodcloseWhere"></a>
<h3>method closeWhere <span class="smalllinenumber">[line 1265]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> closeWhere(
)</code>
</td></tr></table>
</td></tr></table><br />
Add a closing bracket for nesting WHERE conditions.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methoddelete"></a>
<h3>method delete <span class="smalllinenumber">[line 659]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> delete(
[string|false
$table = false])</code>
</td></tr></table>
</td></tr></table><br />
Add a table to DELETE from, or false if deleting from the FROM table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string|false </td>
<td><b>$table</b> </td>
<td>optional table name, default false</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methoddistinct"></a>
<h3>method distinct <span class="smalllinenumber">[line 398]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> distinct(
)</code>
</td></tr></table>
</td></tr></table><br />
Add DISTINCT execution option.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodfrom"></a>
<h3>method from <span class="smalllinenumber">[line 811]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> from(
string
$table, [string
$alias = null])</code>
</td></tr></table>
</td></tr></table><br />
Set the FROM table with optional alias.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>table name</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$alias</b> </td>
<td>optional alias</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetDeleteString"></a>
<h3>method getDeleteString <span class="smalllinenumber">[line 703]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getDeleteString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the DELETE portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>DELETE portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'DELETE' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetFrom"></a>
<h3>method getFrom <span class="smalllinenumber">[line 837]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getFrom(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the FROM table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>FROM table</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetFromAlias"></a>
<h3>method getFromAlias <span class="smalllinenumber">[line 846]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getFromAlias(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the FROM table alias.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>FROM table alias</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetFromString"></a>
<h3>method getFromString <span class="smalllinenumber">[line 1010]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getFromString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the FROM portion of the query, including all JOINs, as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>FROM portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'FROM' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetGroupByString"></a>
<h3>method getGroupByString <span class="smalllinenumber">[line 1444]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getGroupByString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the GROUP BY portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>GROUP BY portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'GROUP BY' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetHavingPlaceholderValues"></a>
<h3>method getHavingPlaceholderValues <span class="smalllinenumber">[line 1616]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>array getHavingPlaceholderValues(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the HAVING placeholder values when <a href="../QueryBuilder/QueryBuilder.html#methodgetHavingString">QueryBuilder::getHavingString()</a> is called with the parameter to use placeholder values.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>HAVING placeholder values</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetHavingString"></a>
<h3>method getHavingString <span class="smalllinenumber">[line 1599]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getHavingString(
[bool
$usePlaceholders = true], [bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the HAVING portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>HAVING portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$usePlaceholders</b> </td>
<td>optional use ? placeholders, default true</td>
</tr>
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'HAVING' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetInsert"></a>
<h3>method getInsert <span class="smalllinenumber">[line 498]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getInsert(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the INSERT table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>INSERT table</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetInsertString"></a>
<h3>method getInsertString <span class="smalllinenumber">[line 508]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getInsertString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the INSERT portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>INSERT portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'INSERT' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetJoinString"></a>
<h3>method getJoinString <span class="smalllinenumber">[line 966]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getJoinString(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the JOIN portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>JOIN portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetLimit"></a>
<h3>method getLimit <span class="smalllinenumber">[line 1703]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>int|string getLimit(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the LIMIT on number of rows to return.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>LIMIT on number of rows to return</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetLimitOffset"></a>
<h3>method getLimitOffset <span class="smalllinenumber">[line 1712]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>int|string getLimitOffset(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the LIMIT row number to start at.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>LIMIT row number to start at</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetLimitString"></a>
<h3>method getLimitString <span class="smalllinenumber">[line 1722]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getLimitString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the LIMIT portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>LIMIT portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'LIMIT' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetOptionsString"></a>
<h3>method getOptionsString <span class="smalllinenumber">[line 354]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getOptionsString(
[bool
$includeTrailingSpace = false])</code>
</td></tr></table>
</td></tr></table><br />
Get the execution options portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>execution options portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeTrailingSpace</b> </td>
<td>optional include space after options</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetOrderByString"></a>
<h3>method getOrderByString <span class="smalllinenumber">[line 1654]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getOrderByString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the ORDER BY portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>ORDER BY portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'ORDER BY' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetPdoConnection"></a>
<h3>method getPdoConnection <span class="smalllinenumber">[line 308]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PDO|null getPdoConnection(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the PDO database connection to use in executing this query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetPlaceholderValues"></a>
<h3>method getPlaceholderValues <span class="smalllinenumber">[line 2046]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>array getPlaceholderValues(
)</code>
</td></tr></table>
</td></tr></table><br />
Get all placeholder values when <a href="../QueryBuilder/QueryBuilder.html#methodgetQueryString">QueryBuilder::getQueryString()</a> is called with the parameter to use placeholder values.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>all placeholder values</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetQueryString"></a>
<h3>method getQueryString <span class="smalllinenumber">[line 2018]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getQueryString(
[bool
$usePlaceholders = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the full query string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>full query string</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$usePlaceholders</b> </td>
<td>optional use ? placeholders, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetReplace"></a>
<h3>method getReplace <span class="smalllinenumber">[line 559]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getReplace(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the REPLACE table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>REPLACE table</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetReplaceString"></a>
<h3>method getReplaceString <span class="smalllinenumber">[line 569]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getReplaceString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the REPLACE portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>REPLACE portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'REPLACE' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSelectString"></a>
<h3>method getSelectString <span class="smalllinenumber">[line 437]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getSelectString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the SELECT portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>SELECT portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'SELECT' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSetPlaceholderValues"></a>
<h3>method getSetPlaceholderValues <span class="smalllinenumber">[line 800]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>array getSetPlaceholderValues(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the SET placeholder values when <a href="../QueryBuilder/QueryBuilder.html#methodgetSetString">QueryBuilder::getSetString()</a> is called with the parameter to use placeholder values.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>SET placeholder values</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSetString"></a>
<h3>method getSetString <span class="smalllinenumber">[line 770]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getSetString(
[bool
$usePlaceholders = true], [bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the SET portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>SET portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$usePlaceholders</b> </td>
<td>optional use ? placeholders, default true</td>
</tr>
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'SET' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetUpdate"></a>
<h3>method getUpdate <span class="smalllinenumber">[line 620]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getUpdate(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the UPDATE table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>UPDATE table</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetUpdateString"></a>
<h3>method getUpdateString <span class="smalllinenumber">[line 630]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getUpdateString(
[bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the UPDATE portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>UPDATE portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'UPDATE' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetWherePlaceholderValues"></a>
<h3>method getWherePlaceholderValues <span class="smalllinenumber">[line 1406]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>array getWherePlaceholderValues(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the WHERE placeholder values when <a href="../QueryBuilder/QueryBuilder.html#methodgetWhereString">QueryBuilder::getWhereString()</a> is called with the parameter to use placeholder values.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>WHERE placeholder values</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetWhereString"></a>
<h3>method getWhereString <span class="smalllinenumber">[line 1389]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string getWhereString(
[bool
$usePlaceholders = true], [bool
$includeText = true])</code>
</td></tr></table>
</td></tr></table><br />
Get the WHERE portion of the query as a string.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>WHERE portion of the query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">bool </td>
<td><b>$usePlaceholders</b> </td>
<td>optional use ? placeholders, default true</td>
</tr>
<tr>
<td class="type">bool </td>
<td><b>$includeText</b> </td>
<td>optional include 'WHERE' text, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgroupBy"></a>
<h3>method groupBy <span class="smalllinenumber">[line 1417]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> groupBy(
string
$column, [string
$order = self::ORDER_BY_ASC])</code>
</td></tr></table>
</td></tr></table><br />
Add a GROUP BY column.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$order</b> </td>
<td>optional order direction, default ASC</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodhaving"></a>
<h3>method having <span class="smalllinenumber">[line 1488]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> having(
string
$column, mixed
$value, [string
$operator = self::EQUALS], [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a HAVING condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>colum name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$operator</b> </td>
<td>optional comparison operator, default =</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodhavingBetween"></a>
<h3>method havingBetween <span class="smalllinenumber">[line 1549]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> havingBetween(
string
$column, mixed
$min, mixed
$max, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a BETWEEN HAVING condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$min</b> </td>
<td>minimum value</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$max</b> </td>
<td>maximum value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodhavingIn"></a>
<h3>method havingIn <span class="smalllinenumber">[line 1524]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> havingIn(
string
$column,
$values, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add an IN WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">array </td>
<td><b>$values</b> </td>
<td>values</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodhavingNotBetween"></a>
<h3>method havingNotBetween <span class="smalllinenumber">[line 1562]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> havingNotBetween(
string
$column, mixed
$min, mixed
$max, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a NOT BETWEEN HAVING condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$min</b> </td>
<td>minimum value</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$max</b> </td>
<td>maximum value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodhavingNotIn"></a>
<h3>method havingNotIn <span class="smalllinenumber">[line 1536]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> havingNotIn(
string
$column,
$values, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a NOT IN HAVING condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">array </td>
<td><b>$values</b> </td>
<td>values</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodinnerJoin"></a>
<h3>method innerJoin <span class="smalllinenumber">[line 880]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> innerJoin(
string
$table, [string|array
$criteria = null], [string
$alias = null])</code>
</td></tr></table>
</td></tr></table><br />
Add an INNER JOIN table with optional ON criteria.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>table name</td>
</tr>
<tr>
<td class="type">string|array </td>
<td><b>$criteria</b> </td>
<td>optional ON criteria</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$alias</b> </td>
<td>optional alias</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodinsert"></a>
<h3>method insert <span class="smalllinenumber">[line 471]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> insert(
string
$table)</code>
</td></tr></table>
</td></tr></table><br />
Set the INSERT table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>INSERT table</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodisDelete"></a>
<h3>method isDelete <span class="smalllinenumber">[line 1783]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>bool isDelete(
)</code>
</td></tr></table>
</td></tr></table><br />
Whether this is a DELETE query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>whether this is a DELETE query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodisInsert"></a>
<h3>method isInsert <span class="smalllinenumber">[line 1756]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>bool isInsert(
)</code>
</td></tr></table>
</td></tr></table><br />
Whether this is an INSERT query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>whether this is an INSERT query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodisReplace"></a>
<h3>method isReplace <span class="smalllinenumber">[line 1765]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>bool isReplace(
)</code>
</td></tr></table>
</td></tr></table><br />
Whether this is a REPLACE query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>whether this is a REPLACE query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodisSelect"></a>
<h3>method isSelect <span class="smalllinenumber">[line 1747]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>bool isSelect(
)</code>
</td></tr></table>
</td></tr></table><br />
Whether this is a SELECT query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>whether this is a SELECT query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodisUpdate"></a>
<h3>method isUpdate <span class="smalllinenumber">[line 1774]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>bool isUpdate(
)</code>
</td></tr></table>
</td></tr></table><br />
Whether this is an UPDATE query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>whether this is an UPDATE query</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodjoin"></a>
<h3>method join <span class="smalllinenumber">[line 859]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> join(
string
$table, [string|array
$criteria = null], [string
$type = self::INNER_JOIN], [string
$alias = null])</code>
</td></tr></table>
</td></tr></table><br />
Add a JOIN table with optional ON criteria.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>table name</td>
</tr>
<tr>
<td class="type">string|array </td>
<td><b>$criteria</b> </td>
<td>optional ON criteria</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$type</b> </td>
<td>optional type of join, default INNER JOIN</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$alias</b> </td>
<td>optional alias</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodleftJoin"></a>
<h3>method leftJoin <span class="smalllinenumber">[line 892]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> leftJoin(
string
$table, [string|array
$criteria = null], [string
$alias = null])</code>
</td></tr></table>
</td></tr></table><br />
Add a LEFT JOIN table with optional ON criteria.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>table name</td>
</tr>
<tr>
<td class="type">string|array </td>
<td><b>$criteria</b> </td>
<td>optional ON criteria</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$alias</b> </td>
<td>optional alias</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodlimit"></a>
<h3>method limit <span class="smalllinenumber">[line 1677]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> limit(
int|string
$limit, [int|string
$offset = 0])</code>
</td></tr></table>
</td></tr></table><br />
Set the LIMIT on number of rows to return with optional offset.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int|string </td>
<td><b>$limit</b> </td>
<td>number of rows to return</td>
</tr>
<tr>
<td class="type">int|string </td>
<td><b>$offset</b> </td>
<td>optional row number to start at, default 0</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeDeleteInto"></a>
<h3>method mergeDeleteInto <span class="smalllinenumber">[line 682]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeDeleteInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's DELETE into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeFromInto"></a>
<h3>method mergeFromInto <span class="smalllinenumber">[line 824]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeFromInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's FROM into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeGroupByInto"></a>
<h3>method mergeGroupByInto <span class="smalllinenumber">[line 1430]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeGroupByInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's GROUP BY into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeHavingInto"></a>
<h3>method mergeHavingInto <span class="smalllinenumber">[line 1572]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeHavingInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's HAVING into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeInsertInto"></a>
<h3>method mergeInsertInto <span class="smalllinenumber">[line 483]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeInsertInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's INSERT into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeInto"></a>
<h3>method mergeInto <span class="smalllinenumber">[line 1794]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder, [bool
$overwriteLimit = true])</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
<tr>
<td class="type">bool </td>
<td><b>$overwriteLimit</b> </td>
<td>optional overwrite limit, default true</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeJoinInto"></a>
<h3>method mergeJoinInto <span class="smalllinenumber">[line 914]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeJoinInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's JOINs into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeLimitInto"></a>
<h3>method mergeLimitInto <span class="smalllinenumber">[line 1690]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeLimitInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's LIMIT into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeOptionsInto"></a>
<h3>method mergeOptionsInto <span class="smalllinenumber">[line 376]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeOptionsInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's execution options into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeOrderByInto"></a>
<h3>method mergeOrderByInto <span class="smalllinenumber">[line 1640]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeOrderByInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's ORDER BY into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeReplaceInto"></a>
<h3>method mergeReplaceInto <span class="smalllinenumber">[line 544]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeReplaceInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's REPLACE into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeSelectInto"></a>
<h3>method mergeSelectInto <span class="smalllinenumber">[line 421]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeSelectInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's SELECT into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeSetInto"></a>
<h3>method mergeSetInto <span class="smalllinenumber">[line 755]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeSetInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's SET into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeUpdateInto"></a>
<h3>method mergeUpdateInto <span class="smalllinenumber">[line 605]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeUpdateInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's UPDATE into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodmergeWhereInto"></a>
<h3>method mergeWhereInto <span class="smalllinenumber">[line 1362]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> mergeWhereInto(
<a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a>
$QueryBuilder)</code>
</td></tr></table>
</td></tr></table><br />
Merge this QueryBuilder's WHERE into the given QueryBuilder.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> </td>
<td><b>$QueryBuilder</b> </td>
<td>to merge into</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodopenHaving"></a>
<h3>method openHaving <span class="smalllinenumber">[line 1466]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> openHaving(
[string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add an open bracket for nesting HAVING conditions.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodopenWhere"></a>
<h3>method openWhere <span class="smalllinenumber">[line 1256]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> openWhere(
[string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add an open bracket for nesting WHERE conditions.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodoption"></a>
<h3>method option <span class="smalllinenumber">[line 342]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> option(
string
$option)</code>
</td></tr></table>
</td></tr></table><br />
Add an execution option like DISTINCT or SQL_CALC_FOUND_ROWS.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$option</b> </td>
<td>execution option to add</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodorderBy"></a>
<h3>method orderBy <span class="smalllinenumber">[line 1627]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> orderBy(
string
$column, [string
$order = self::ORDER_BY_ASC])</code>
</td></tr></table>
</td></tr></table><br />
Add a column to ORDER BY.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$order</b> </td>
<td>optional order direction, default ASC</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodorHaving"></a>
<h3>method orHaving <span class="smalllinenumber">[line 1512]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> orHaving(
string
$column, mixed
$value, [string
$operator = self::EQUALS])</code>
</td></tr></table>
</td></tr></table><br />
Add an OR HAVING condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>colum name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$operator</b> </td>
<td>optional comparison operator, default =</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodorWhere"></a>
<h3>method orWhere <span class="smalllinenumber">[line 1302]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> orWhere(
string
$column, mixed
$value, [string
$operator = self::EQUALS])</code>
</td></tr></table>
</td></tr></table><br />
Add an OR WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>colum name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$operator</b> </td>
<td>optional comparison operator, default =</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodquery"></a>
<h3>method query <span class="smalllinenumber">[line 2057]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PDOStatement|false query(
)</code>
</td></tr></table>
</td></tr></table><br />
Execute the query using the PDO database connection.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>executed query or false if failed</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodquote"></a>
<h3>method quote <span class="smalllinenumber">[line 318]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string|false quote(
string
$value)</code>
</td></tr></table>
</td></tr></table><br />
Safely escape a value for use in a query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>escaped value or false if failed</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$value</b> </td>
<td>value to escape</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodreplace"></a>
<h3>method replace <span class="smalllinenumber">[line 532]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> replace(
string
$table)</code>
</td></tr></table>
</td></tr></table><br />
Set the REPLACE table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>REPLACE table</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodrightJoin"></a>
<h3>method rightJoin <span class="smalllinenumber">[line 904]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> rightJoin(
string
$table, [string|array
$criteria = null], [string
$alias = null])</code>
</td></tr></table>
</td></tr></table><br />
Add a RIGHT JOIN table with optional ON criteria.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>table name</td>
</tr>
<tr>
<td class="type">string|array </td>
<td><b>$criteria</b> </td>
<td>optional ON criteria</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$alias</b> </td>
<td>optional alias</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodselect"></a>
<h3>method select <span class="smalllinenumber">[line 409]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> select(
string
$column, [string
$alias = null])</code>
</td></tr></table>
</td></tr></table><br />
Add a SELECT column, table, or expression with optional alias.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name, table name, or expression</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$alias</b> </td>
<td>optional alias</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodset"></a>
<h3>method set <span class="smalllinenumber">[line 742]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> set(
string
$column, mixed
$value)</code>
</td></tr></table>
</td></tr></table><br />
Add a column value to INSERT or UPDATE.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsetPdoConnection"></a>
<h3>method setPdoConnection <span class="smalllinenumber">[line 297]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> setPdoConnection(
[
$PdoConnection = null])</code>
</td></tr></table>
</td></tr></table><br />
Set the PDO database connection to use in executing this query.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">PDO|null </td>
<td><b>$PdoConnection</b> </td>
<td>optional PDO database connection</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodupdate"></a>
<h3>method update <span class="smalllinenumber">[line 593]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> update(
string
$table)</code>
</td></tr></table>
</td></tr></table><br />
Set the UPDATE table.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$table</b> </td>
<td>UPDATE table</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodwhere"></a>
<h3>method where <span class="smalllinenumber">[line 1278]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> where(
string
$column, mixed
$value, [string
$operator = self::EQUALS], [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$value</b> </td>
<td>value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$operator</b> </td>
<td>optional comparison operator, default =</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodwhereBetween"></a>
<h3>method whereBetween <span class="smalllinenumber">[line 1339]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> whereBetween(
string
$column, mixed
$min, mixed
$max, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a BETWEEN WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$min</b> </td>
<td>minimum value</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$max</b> </td>
<td>maximum value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodwhereIn"></a>
<h3>method whereIn <span class="smalllinenumber">[line 1314]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> whereIn(
string
$column,
$values, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add an IN WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">array </td>
<td><b>$values</b> </td>
<td>values</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodwhereNotBetween"></a>
<h3>method whereNotBetween <span class="smalllinenumber">[line 1352]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> whereNotBetween(
string
$column, mixed
$min, mixed
$max, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a NOT BETWEEN WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$min</b> </td>
<td>minimum value</td>
</tr>
<tr>
<td class="type">mixed </td>
<td><b>$max</b> </td>
<td>maximum value</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodwhereNotIn"></a>
<h3>method whereNotIn <span class="smalllinenumber">[line 1326]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../QueryBuilder/QueryBuilder.html">QueryBuilder</a> whereNotIn(
string
$column,
$values, [string
$connector = self::LOGICAL_AND])</code>
</td></tr></table>
</td></tr></table><br />
Add a NOT IN WHERE condition.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$column</b> </td>
<td>column name</td>
</tr>
<tr>
<td class="type">array </td>
<td><b>$values</b> </td>
<td>values</td>
</tr>
<tr>
<td class="type">string </td>
<td><b>$connector</b> </td>
<td>optional logical connector, default AND</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="method__toString"></a>
<h3>method __toString <span class="smalllinenumber">[line 2084]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string __toString(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the full query string without value placeholders.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>full query string</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
</div><br />
<hr />
<a name="class_consts"></a>
<h3>Class Constants</h3>
<div class="tags">
<a name="constBETWEEN"></a>
<p></p>
<h4>BETWEEN = <span class="value"> "BETWEEN"</span></h4>
<p>[line 103]</p>
BETWEEN comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constBRACKET_CLOSE"></a>
<p></p>
<h4>BRACKET_CLOSE = <span class="value"> ")"</span></h4>
<p>[line 138]</p>
Closing bracket for grouping criteria.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constBRACKET_OPEN"></a>
<p></p>
<h4>BRACKET_OPEN = <span class="value"> "("</span></h4>
<p>[line 133]</p>
Open bracket for grouping criteria.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constEQUALS"></a>
<p></p>
<h4>EQUALS = <span class="value"> "="</span></h4>
<p>[line 43]</p>
Equals comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constGREATER_THAN"></a>
<p></p>
<h4>GREATER_THAN = <span class="value"> ">"</span></h4>
<p>[line 63]</p>
Greater than comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constGREATER_THAN_OR_EQUAL"></a>
<p></p>
<h4>GREATER_THAN_OR_EQUAL = <span class="value"> ">="</span></h4>
<p>[line 68]</p>
Greater than or equal to comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constIN"></a>
<p></p>
<h4>IN = <span class="value"> "IN"</span></h4>
<p>[line 73]</p>
IN comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constINNER_JOIN"></a>
<p></p>
<h4>INNER_JOIN = <span class="value"> "INNER JOIN"</span></h4>
<p>[line 18]</p>
INNER JOIN type.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constIS"></a>
<p></p>
<h4>IS = <span class="value"> "IS"</span></h4>
<p>[line 113]</p>
IS comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constIS_NOT"></a>
<p></p>
<h4>IS_NOT = <span class="value"> "IS NOT"</span></h4>
<p>[line 118]</p>
IS NOT comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constLEFT_JOIN"></a>
<p></p>
<h4>LEFT_JOIN = <span class="value"> "LEFT JOIN"</span></h4>
<p>[line 23]</p>
LEFT JOIN type.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constLESS_THAN"></a>
<p></p>
<h4>LESS_THAN = <span class="value"> "<"</span></h4>
<p>[line 53]</p>
Less than comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constLESS_THAN_OR_EQUAL"></a>
<p></p>
<h4>LESS_THAN_OR_EQUAL = <span class="value"> "<="</span></h4>
<p>[line 58]</p>
Less than or equal to comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constLIKE"></a>
<p></p>
<h4>LIKE = <span class="value"> "LIKE"</span></h4>
<p>[line 83]</p>
LIKE comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constLOGICAL_AND"></a>
<p></p>
<h4>LOGICAL_AND = <span class="value"> "AND"</span></h4>
<p>[line 33]</p>
AND logical operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constLOGICAL_OR"></a>
<p></p>
<h4>LOGICAL_OR = <span class="value"> "OR"</span></h4>
<p>[line 38]</p>
OR logical operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constNOT_BETWEEN"></a>
<p></p>
<h4>NOT_BETWEEN = <span class="value"> "NOT BETWEEN"</span></h4>
<p>[line 108]</p>
NOT BETWEEN comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constNOT_EQUALS"></a>
<p></p>
<h4>NOT_EQUALS = <span class="value"> "!="</span></h4>
<p>[line 48]</p>
Not equals comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constNOT_IN"></a>
<p></p>
<h4>NOT_IN = <span class="value"> "NOT IN"</span></h4>
<p>[line 78]</p>
NOT IN comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constNOT_LIKE"></a>
<p></p>
<h4>NOT_LIKE = <span class="value"> "NOT LIKE"</span></h4>
<p>[line 88]</p>
NOT LIKE comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constNOT_REGEX"></a>
<p></p>
<h4>NOT_REGEX = <span class="value"> "NOT REGEXP"</span></h4>
<p>[line 98]</p>
NOT REGEXP comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constORDER_BY_ASC"></a>
<p></p>
<h4>ORDER_BY_ASC = <span class="value"> "ASC"</span></h4>
<p>[line 123]</p>
Ascending ORDER BY direction.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constORDER_BY_DESC"></a>
<p></p>
<h4>ORDER_BY_DESC = <span class="value"> "DESC"</span></h4>
<p>[line 128]</p>
Descending ORDER BY direction.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constREGEX"></a>
<p></p>
<h4>REGEX = <span class="value"> "REGEXP"</span></h4>
<p>[line 93]</p>
REGEXP comparison operator.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<a name="constRIGHT_JOIN"></a>
<p></p>
<h4>RIGHT_JOIN = <span class="value"> "RIGHT JOIN"</span></h4>
<p>[line 28]</p>
RIGHT JOIN type.<br /><br />
<br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
</div><br />
<div class="credit">
<hr />
Documentation generated on Wed, 27 Jun 2012 15:45:37 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.3</a>
</div>
</td></tr></table>
</td>
</tr>
</table>
</body>
</html>