JDatabaseQueryPdomysql

Extends \JDatabaseQueryMysqli

Query Building Class.

package

Joomla.Platform

subpackage

Database

since

3.4

Methods

__call

Magic method to provide method alias support for quote() and quoteName().

__call(string $method, array $args) : string
inherited
since

1.7.0

Arguments

$method

stringThe called method.

$args

arrayThe array of arguments passed to the method.

Response

stringThe aliased method's return value or null.

__clone

Method to provide deep copy support to nested objects and arrays when cloning.

__clone() : void
inherited
since

1.7.3

__construct

Class constructor.

__construct(\JDatabaseDriver $db = null) 
inherited
since

1.7.0

Arguments

$db

\JDatabaseDriverThe database driver.

__get

Magic function to get protected variable value

__get(string $name) : mixed
inherited
since

1.7.0

Arguments

$name

stringThe name of the variable.

Response

mixed

__toString

Magic function to convert the query to a string.

__toString() : string
inherited
since

1.7.0

Response

stringThe completed query.

andWhere

Extend the WHERE clause with an AND and a single condition or an array of conditions.

andWhere(mixed $conditions, string $glue = 'OR') : \JDatabaseQuery
inherited

Usage: $query->where(array('a = 1', 'b = 2'))->andWhere(array('c = 3', 'd = 4')); will produce: WHERE ((a = 1 AND b = 2) AND (c = 3 OR d = 4)

since

3.6

Arguments

$conditions

mixedA string or array of WHERE conditions.

$glue

stringThe glue by which to join the conditions. Defaults to OR.

Response

\JDatabaseQueryReturns this object to allow chaining.

call

Add a single column, or array of columns to the CALL clause of the query.

call(mixed $columns) : \JDatabaseQuery
inherited

Note that you must not mix insert, update, delete and select method calls when building a query. The call method can, however, be called multiple times in the same query.

Usage: $query->call('a.')->call('b.id'); $query->call(array('a.', 'b.id'));

since

3.0.0

Arguments

$columns

mixedA string or an array of field names.

Response

\JDatabaseQueryReturns this object to allow chaining.

castAsChar

Casts a value to a char.

castAsChar(string $value) : string
inherited

Ensure that the value is properly quoted before passing to the method.

Usage: $query->select($query->castAsChar('a'));

since

1.7.0

Arguments

$value

stringThe value to cast as a char.

Response

stringReturns the cast value.

charLength

Gets the number of characters in a string.

charLength(string $field, string $operator = null, string $condition = null) : string
inherited

Note, use 'length' to find the number of bytes in a string.

Usage: $query->select($query->charLength('a'));

since

1.7.0

Arguments

$field

stringA value.

$operator

stringComparison operator between charLength integer value and $condition

$condition

stringInteger value to compare charLength with.

Response

stringThe required char length call.

clear

Clear data from the query or a specific clause of the query.

clear(string $clause = null) : \JDatabaseQuery
inherited
since

1.7.0

Arguments

$clause

stringOptionally, the name of the clause to clear, or nothing to clear the whole query.

Response

\JDatabaseQueryReturns this object to allow chaining.

columns

Adds a column, or array of column names that would be used for an INSERT INTO statement.

columns(mixed $columns) : \JDatabaseQuery
inherited
since

1.7.0

Arguments

$columns

mixedA column name, or array of column names.

Response

\JDatabaseQueryReturns this object to allow chaining.

concatenate

Concatenates an array of column names or values.

concatenate(array $values, string $separator = null) : string
inherited

Usage: $query->select($query->concatenate(array('a', 'b')));

since

1.7.0

Arguments

$values

arrayAn array of values to concatenate.

$separator

stringAs separator to place between each value.

Response

stringThe concatenated values.

currentTimestamp

Gets the current date and time.

currentTimestamp() : string
inherited

Usage: $query->where('published_up < '.$query->currentTimestamp());

since

1.7.0

Response

string

dateAdd

Add to the current date and time.

dateAdd(string $date, string $interval, string $datePart) : string
inherited

Usage: $query->select($query->dateAdd()); Prefixing the interval with a - (negative sign) will cause subtraction to be used. Note: Not all drivers support all units.

link

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

since

3.2.0

Arguments

$date

stringThe db quoted string representation of the date to add to. May be date or datetime

$interval

stringThe string representation of the appropriate number of units

$datePart

stringThe part of the date to perform the addition on

Response

stringThe string with the appropriate sql for addition of dates

dateFormat

Returns a PHP date() function compliant date format for the database driver.

dateFormat() : string
inherited

This method is provided for use where the query object is passed to a function for modification. If you have direct access to the database object, it is recommended you use the getDateFormat method directly.

since

1.7.0

Response

stringThe format string.

day

Used to get a string to extract day from date column.

day(string $date) : string
inherited

Usage: $query->select($query->day($query->quoteName('dateColumn')));

since

3.0.0

Arguments

$date

stringDate column containing day to be extracted.

Response

stringReturns string to extract day from a date.

delete

Add a table name to the DELETE clause of the query.

delete(string $table = null) : \JDatabaseQuery
inherited

Note that you must not mix insert, update, delete and select method calls when building a query.

Usage: $query->delete('#__a')->where('id = 1');

since

1.7.0

Arguments

$table

stringThe name of the table to delete from.

Response

\JDatabaseQueryReturns this object to allow chaining.

dump

Creates a formatted dump of the query for debugging purposes.

dump() : string
inherited

Usage: echo $query->dump();

since

1.7.3

Response

string

e

e(mixed $text, \= $extra) : string
inherited

Alias for escape method

Arguments

$text

mixed

$extra

\=

Response

string

escape

Method to escape a string for usage in an SQL statement.

escape(string $text, boolean $extra = false) : string
inherited

This method is provided for use where the query object is passed to a function for modification. If you have direct access to the database object, it is recommended you use the escape method directly.

Note that 'e' is an alias for this method as it is in JDatabaseDriver.

since

1.7.0

throws

\RuntimeExceptionif the internal db property is not a valid object.

Arguments

$text

stringThe string to be escaped.

$extra

booleanOptional parameter to provide extra escaping.

Response

stringThe escaped string.

exec

Add a single column, or array of columns to the EXEC clause of the query.

exec(mixed $columns) : \JDatabaseQuery
inherited

Note that you must not mix insert, update, delete and select method calls when building a query. The exec method can, however, be called multiple times in the same query.

Usage: $query->exec('a.')->exec('b.id'); $query->exec(array('a.', 'b.id'));

since

3.0.0

Arguments

$columns

mixedA string or an array of field names.

Response

\JDatabaseQueryReturns this object to allow chaining.

extendWhere

Extend the WHERE clause with a single condition or an array of conditions, with a potentially different logical operator from the one in the current WHERE clause.

extendWhere(string $outerGlue, mixed $conditions, string $innerGlue = 'AND') : \JDatabaseQuery
inherited

Usage: $query->where(array('a = 1', 'b = 2'))->extendWhere('XOR', array('c = 3', 'd = 4')); will produce: WHERE ((a = 1 AND b = 2) XOR (c = 3 AND d = 4)

since

3.6

Arguments

$outerGlue

stringThe glue by which to join the conditions to the current WHERE conditions.

$conditions

mixedA string or array of WHERE conditions.

$innerGlue

stringThe glue by which to join the conditions. Defaults to AND.

Response

\JDatabaseQueryReturns this object to allow chaining.

format

Find and replace sprintf-like tokens in a format string.

format(string $format) : string
inherited

Each token takes one of the following forms: %% - A literal percent character. %[t] - Where [t] is a type specifier. %[n]$[x] - Where [n] is an argument specifier and [t] is a type specifier.

Types: a - Numeric: Replacement text is coerced to a numeric type but not quoted or escaped. e - Escape: Replacement text is passed to $this->escape(). E - Escape (extra): Replacement text is passed to $this->escape() with true as the second argument. n - Name Quote: Replacement text is passed to $this->quoteName(). q - Quote: Replacement text is passed to $this->quote(). Q - Quote (no escape): Replacement text is passed to $this->quote() with false as the second argument. r - Raw: Replacement text is used as-is. (Be careful)

Date Types:

  • Replacement text automatically quoted (use uppercase for Name Quote).
  • Replacement text should be a string in date format or name of a date column. y/Y - Year m/M - Month d/D - Day h/H - Hour i/I - Minute s/S - Second

Invariable Types:

  • Takes no argument.
  • Argument index not incremented. t - Replacement text is the result of $this->currentTimestamp(). z - Replacement text is the result of $this->nullDate(false). Z - Replacement text is the result of $this->nullDate(true).

Usage: $query->format('SELECT %1$n FROM %2$n WHERE %3$n = %4$a', 'foo', '#foo', 'bar', 1); Returns: SELECT foo FROM `#fooWHEREbar` = 1

Notes: The argument specifier is optional but recommended for clarity. The argument index used for unspecified tokens is incremented only when used.

since

3.1.4

Arguments

$format

stringThe formatting string.

Response

stringReturns a string produced according to the formatting string.

from

Add a table to the FROM clause of the query.

from(mixed $tables, string $subQueryAlias = null) : \JDatabaseQuery
inherited

Note that while an array of tables can be provided, it is recommended you use explicit joins.

Usage: $query->select('*')->from('#__a');

throws

\RuntimeException

since

1.7.0

Arguments

$tables

mixedA string or array of table names. This can be a JDatabaseQuery object (or a child of it) when used as a subquery in FROM clause along with a value for $subQueryAlias.

$subQueryAlias

stringAlias used when $tables is a JDatabaseQuery.

Response

\JDatabaseQueryReturns this object to allow chaining.

group

Add a grouping column to the GROUP clause of the query.

group(mixed $columns) : \JDatabaseQuery
inherited

Usage: $query->group('id');

since

1.7.0

Arguments

$columns

mixedA string or array of ordering columns.

Response

\JDatabaseQueryReturns this object to allow chaining.

having

A conditions to the HAVING clause of the query.

having(mixed $conditions, string $glue = 'AND') : \JDatabaseQuery
inherited

Usage: $query->group('id')->having('COUNT(id) > 5');

since

1.7.0

Arguments

$conditions

mixedA string or array of columns.

$glue

stringThe glue by which to join the conditions. Defaults to AND.

Response

\JDatabaseQueryReturns this object to allow chaining.

hour

Used to get a string to extract hour from date column.

hour(string $date) : string
inherited

Usage: $query->select($query->hour($query->quoteName('dateColumn')));

since

3.0.0

Arguments

$date

stringDate column containing hour to be extracted.

Response

stringReturns string to extract hour from a date.

innerJoin

Add an INNER JOIN clause to the query.

innerJoin(string $condition) : \JDatabaseQuery
inherited

Usage: $query->innerJoin('b ON b.id = a.id')->innerJoin('c ON c.id = b.id');

since

1.7.0

Arguments

$condition

stringThe join condition.

Response

\JDatabaseQueryReturns this object to allow chaining.

insert

Add a table name to the INSERT clause of the query.

insert(mixed $table, boolean $incrementField = false) : \JDatabaseQuery
inherited

Note that you must not mix insert, update, delete and select method calls when building a query.

Usage: $query->insert('#a')->set('id = 1'); $query->insert('#a')->columns('id, title')->values('1,2')->values('3,4'); $query->insert('#__a')->columns('id, title')->values(array('1,2', '3,4'));

since

1.7.0

Arguments

$table

mixedThe name of the table to insert data into.

$incrementField

booleanThe name of the field to auto increment.

Response

\JDatabaseQueryReturns this object to allow chaining.

join

Add a JOIN clause to the query.

join(string $type, string $conditions) : \JDatabaseQuery
inherited

Usage: $query->join('INNER', 'b ON b.id = a.id);

since

1.7.0

Arguments

$type

stringThe type of join. This string is prepended to the JOIN keyword.

$conditions

stringA string or array of conditions.

Response

\JDatabaseQueryReturns this object to allow chaining.

leftJoin

Add a LEFT JOIN clause to the query.

leftJoin(string $condition) : \JDatabaseQuery
inherited

Usage: $query->leftJoin('b ON b.id = a.id')->leftJoin('c ON c.id = b.id');

since

1.7.0

Arguments

$condition

stringThe join condition.

Response

\JDatabaseQueryReturns this object to allow chaining.

length

Get the length of a string in bytes.

length(string $value) : integer
inherited

Note, use 'charLength' to find the number of characters in a string.

Usage: query->where($query->length('a').' > 3');

since

1.7.0

Arguments

$value

stringThe string to measure.

Response

integer

minute

Used to get a string to extract minute from date column.

minute(string $date) : string
inherited

Usage: $query->select($query->minute($query->quoteName('dateColumn')));

since

3.0.0

Arguments

$date

stringDate column containing minute to be extracted.

Response

stringReturns string to extract minute from a date.

month

Used to get a string to extract month from date column.

month(string $date) : string
inherited

Usage: $query->select($query->month($query->quoteName('dateColumn')));

since

3.0.0

Arguments

$date

stringDate column containing month to be extracted.

Response

stringReturns string to extract month from a date.

nullDate

Get the null or zero representation of a timestamp for the database driver.

nullDate(boolean $quoted = true) : string
inherited

This method is provided for use where the query object is passed to a function for modification. If you have direct access to the database object, it is recommended you use the nullDate method directly.

Usage: $query->where('modified_date <> '.$query->nullDate());

since

1.7.0

Arguments

$quoted

booleanOptionally wraps the null date in database quotes (true by default).

Response

stringNull or zero representation of a timestamp.

order

Add an ordering column to the ORDER clause of the query.

order(mixed $columns) : \JDatabaseQuery
inherited

Usage: $query->order('foo')->order('bar'); $query->order(array('foo','bar'));

since

1.7.0

Arguments

$columns

mixedA string or array of ordering columns.

Response

\JDatabaseQueryReturns this object to allow chaining.

orWhere

Extend the WHERE clause with an OR and a single condition or an array of conditions.

orWhere(mixed $conditions, string $glue = 'AND') : \JDatabaseQuery
inherited

Usage: $query->where(array('a = 1', 'b = 2'))->orWhere(array('c = 3', 'd = 4')); will produce: WHERE ((a = 1 AND b = 2) OR (c = 3 AND d = 4)

since

3.6

Arguments

$conditions

mixedA string or array of WHERE conditions.

$glue

stringThe glue by which to join the conditions. Defaults to AND.

Response

\JDatabaseQueryReturns this object to allow chaining.

outerJoin

Add an OUTER JOIN clause to the query.

outerJoin(string $condition) : \JDatabaseQuery
inherited

Usage: $query->outerJoin('b ON b.id = a.id')->outerJoin('c ON c.id = b.id');

since

1.7.0

Arguments

$condition

stringThe join condition.

Response

\JDatabaseQueryReturns this object to allow chaining.

processLimit

Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset.

processLimit(string $query, integer $limit, integer $offset) : string
inherited
since

3.0.0

Arguments

$query

stringThe query in string format

$limit

integerThe limit for the result set

$offset

integerThe offset for the result set

Response

string

q

q(mixed $text, \= $escape) : string
inherited

Alias for quote method

Arguments

$text

mixed

$escape

\=

Response

string

qn

qn(mixed $name, \= $as) : string
inherited

Alias for quoteName method

Arguments

$name

mixed

$as

\=

Response

string

quote

Method to quote and optionally escape a string to database requirements for insertion into the database.

quote(mixed $text, boolean $escape = true) : string
inherited

This method is provided for use where the query object is passed to a function for modification. If you have direct access to the database object, it is recommended you use the quote method directly.

Note that 'q' is an alias for this method as it is in JDatabaseDriver.

Usage: $query->quote('fulltext'); $query->q('fulltext'); $query->q(array('option', 'fulltext'));

since

1.7.0

throws

\RuntimeExceptionif the internal db property is not a valid object.

Arguments

$text

mixedA string or an array of strings to quote.

$escape

booleanTrue to escape the string, false to leave it unchanged.

Response

stringThe quoted input string.

quoteName

Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.

quoteName(mixed $name, mixed $as = null) : mixed
inherited

This method is provided for use where the query object is passed to a function for modification. If you have direct access to the database object, it is recommended you use the quoteName method directly.

Note that 'qn' is an alias for this method as it is in JDatabaseDriver.

Usage: $query->quoteName('#a'); $query->qn('#a');

since

1.7.0

throws

\RuntimeExceptionif the internal db property is not a valid object.

Arguments

$name

mixedThe identifier name to wrap in quotes, or an array of identifier names to wrap in quotes. Each type supports dot-notation name.

$as

mixedThe AS query part associated to $name. It can be string or array, in latter case it has to be same length of $name; if is null there will not be any AS part for string or array element.

Response

mixedThe quote wrapped name, same type of $name.

Rand

Return correct rand() function for Mysql.

Rand() : string
inherited

Ensure that the rand() function is Mysql compatible.

Usage: $query->Rand();

since

3.5

Response

stringThe correct rand function.

regexp

Return correct regexp operator for mysqli.

regexp(string $value) : string
inherited

Ensure that the regexp operator is mysqli compatible.

Usage: $query->where('field ' . $query->regexp($search));

since

1.7.3

Arguments

$value

stringThe regex pattern.

Response

stringReturns the regex operator.

rightJoin

Add a RIGHT JOIN clause to the query.

rightJoin(string $condition) : \JDatabaseQuery
inherited

Usage: $query->rightJoin('b ON b.id = a.id')->rightJoin('c ON c.id = b.id');

since

1.7.0

Arguments

$condition

stringThe join condition.

Response

\JDatabaseQueryReturns this object to allow chaining.

second

Used to get a string to extract seconds from date column.

second(string $date) : string
inherited

Usage: $query->select($query->second($query->quoteName('dateColumn')));

since

3.0.0

Arguments

$date

stringDate column containing second to be extracted.

Response

stringReturns string to extract second from a date.

select

Add a single column, or array of columns to the SELECT clause of the query.

select(mixed $columns) : \JDatabaseQuery
inherited

Note that you must not mix insert, update, delete and select method calls when building a query. The select method can, however, be called multiple times in the same query.

Usage: $query->select('a.')->select('b.id'); $query->select(array('a.', 'b.id'));

since

1.7.0

Arguments

$columns

mixedA string or an array of field names.

Response

\JDatabaseQueryReturns this object to allow chaining.

selectRowNumber

Return the number of the current row.

selectRowNumber(string $orderBy, string $orderColumnAlias) : \JDatabaseQuery
inherited

Usage: $query->select('id'); $query->selectRowNumber('ordering,publish_up DESC', 'new_ordering'); $query->from('#__content');

since

3.7.0

throws

\RuntimeException

Arguments

$orderBy

stringAn expression of ordering for window function.

$orderColumnAlias

stringAn alias for new ordering column.

Response

\JDatabaseQueryReturns this object to allow chaining.

set

Add a single condition string, or an array of strings to the SET clause of the query.

set(mixed $conditions, string $glue = ',') : \JDatabaseQuery
inherited

Usage: $query->set('a = 1')->set('b = 2'); $query->set(array('a = 1', 'b = 2');

since

1.7.0

Arguments

$conditions

mixedA string or array of string conditions.

$glue

stringThe glue by which to join the condition strings. Defaults to ,. Note that the glue is set on first use and cannot be changed.

Response

\JDatabaseQueryReturns this object to allow chaining.

setLimit

Sets the offset and limit for the result set, if the database driver supports it.

setLimit(integer $limit, integer $offset) : \JDatabaseQuery
inherited

Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)

since

3.0.0

Arguments

$limit

integerThe limit for the result set

$offset

integerThe offset for the result set

Response

\JDatabaseQueryReturns this object to allow chaining.

setQuery

Allows a direct query to be provided to the database driver's setQuery() method, but still allow queries to have bounded variables.

setQuery(mixed $sql) : \JDatabaseQuery
inherited

Usage: $query->setQuery('select * from #__users');

since

3.0.0

Arguments

$sql

mixedAn SQL Query

Response

\JDatabaseQueryReturns this object to allow chaining.

union

Add a query to UNION with the current query.

union(mixed $query, boolean $distinct = false, string $glue = '') : \JDatabaseQuery
inherited

Multiple unions each require separate statements and create an array of unions.

Usage (the $query base query MUST be a select query): $query->union('SELECT name FROM #foo') $query->union('SELECT name FROM #foo', true) $query->union($query2)->union($query3)

The $query attribute as an array is deprecated and will not be supported in 4.0.

$query->union(array('SELECT name FROM #foo','SELECT name FROM #bar')) $query->union(array($query2, $query3))

link

http://dev.mysql.com/doc/refman/5.0/en/union.html

since

3.0.0

Arguments

$query

mixedThe JDatabaseQuery object or string to union.

$distinct

booleanTrue to only return distinct rows from the union.

$glue

stringThe glue by which to join the conditions.

Response

\JDatabaseQueryReturns this object to allow chaining.

unionAll

Add a query to UNION ALL with the current query.

unionAll(mixed $query, boolean $distinct = false, string $glue = '') : \JDatabaseQuery
inherited

Multiple unions each require separate statements and create an array of unions.

Usage: $query->union('SELECT name FROM #__foo')

The $query attribute as an array is deprecated and will not be supported in 4.0.

$query->union(array('SELECT name FROM #foo','SELECT name FROM #bar'))

see \union
since

3.2.0

Arguments

$query

mixedThe JDatabaseQuery object or string to union.

$distinct

booleanNot used - ignored.

$glue

stringNot used - ignored.

Response

\JDatabaseQueryReturns this object to allow chaining.

unionDistinct

Add a query to UNION DISTINCT with the current query. Simply a proxy to union with the DISTINCT keyword.

unionDistinct(mixed $query, string $glue = '') : \JDatabaseQuery
inherited deprecated

Usage: $query->unionDistinct('SELECT name FROM #__foo')

see \union
since

3.0.0

deprecated

4.0 Use union() instead.

Arguments

$query

mixedThe JDatabaseQuery object or string to union.

$glue

stringThe glue by which to join the conditions.

Response

\JDatabaseQueryReturns this object to allow chaining.

update

Add a table name to the UPDATE clause of the query.

update(string $table) : \JDatabaseQuery
inherited

Note that you must not mix insert, update, delete and select method calls when building a query.

Usage: $query->update('#__foo')->set(...);

since

1.7.0

Arguments

$table

stringA table to update.

Response

\JDatabaseQueryReturns this object to allow chaining.

validateRowNumber

Validate arguments which are passed to selectRowNumber method and set up common variables.

validateRowNumber(string $orderBy, string $orderColumnAlias) : void
inherited
since

3.7.0

throws

\RuntimeException

Arguments

$orderBy

stringAn expression of ordering for window function.

$orderColumnAlias

stringAn alias for new ordering column.

values

Adds a tuple, or array of tuples that would be used as values for an INSERT INTO statement.

values(string $values) : \JDatabaseQuery
inherited

Usage: $query->values('1,2,3')->values('4,5,6'); $query->values(array('1,2,3', '4,5,6'));

since

1.7.0

Arguments

$values

stringA single tuple, or array of tuples.

Response

\JDatabaseQueryReturns this object to allow chaining.

where

Add a single condition, or an array of conditions to the WHERE clause of the query.

where(mixed $conditions, string $glue = 'AND') : \JDatabaseQuery
inherited

Usage: $query->where('a = 1')->where('b = 2'); $query->where(array('a = 1', 'b = 2'));

since

1.7.0

Arguments

$conditions

mixedA string or array of where conditions.

$glue

stringThe glue by which to join the conditions. Defaults to AND. Note that the glue is set on first use and cannot be changed.

Response

\JDatabaseQueryReturns this object to allow chaining.

year

Used to get a string to extract year from date column.

year(string $date) : string
inherited

Usage: $query->select($query->year($query->quoteName('dateColumn')));

since

3.0.0

Arguments

$date

stringDate column containing year to be extracted.

Response

stringReturns string to extract year from a date.

Properties

offset

The offset for the result set.

inherited
since

3.0.0

Type(s)

integer

limit

The limit for the result set.

inherited
since

3.0.0

Type(s)

integer

db

The database driver.

inherited
since

1.7.0

Type(s)

\JDatabaseDriver

sql

The SQL query (if a direct query string was provided).

inherited
since

3.0.0

Type(s)

string

type

The query type.

inherited
since

1.7.0

Type(s)

string

element

The query element for a generic query (type = null).

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

select

The select element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

delete

The delete element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

update

The update element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

insert

The insert element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

from

The from element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

join

The join element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

set

The set element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

where

The where element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

group

The group by element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

having

The having element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

columns

The column list for an INSERT statement.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

values

The values list for an INSERT statement.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

order

The order element.

inherited
since

1.7.0

Type(s)

\JDatabaseQueryElement

autoIncrementField

The auto increment insert field element.

inherited
since

1.7.0

Type(s)

object

call

The call element.

inherited
since

3.0.0

Type(s)

\JDatabaseQueryElement

exec

The exec element.

inherited
since

3.0.0

Type(s)

\JDatabaseQueryElement

union

The union element.

inherited deprecated
since

3.0.0

deprecated

4.0 Will be transformed and moved to $merge variable.

Type(s)

\JDatabaseQueryElement

unionAll

The unionAll element.

inherited deprecated
since

3.2.0

deprecated

4.0 Will be transformed and moved to $merge variable.

Type(s)

\JDatabaseQueryElement

selectRowNumber

Details of window function.

inherited
since

3.7.0

Type(s)

array

type

inherited

Type(s)

\JDatabaseQueryElement

select

inherited

Type(s)

\JDatabaseQueryElement

group

inherited

Type(s)

\JDatabaseQueryElement

having

inherited

Type(s)

\JDatabaseQueryElement