WP_Meta_Query::__construct() – Method

Constructor.

Parameters

$meta_queryarrayoptional

Array of meta query clauses. When first-order clauses or sub-clauses use strings as their array keys, they may be referenced in the ‘orderby’ parameter of the parent query.

relation string
Optional. The MySQL keyword used to join the clauses of the query.
Accepts 'AND' or 'OR'. Default 'AND'.
...$0 array
Optional. An array of first-order clause parameters, or another fully-formed meta query.
- key string|string[]
  Meta key or keys to filter by.
- compare_key string
  MySQL operator used for comparing the $key. Accepts:
  - '='
  - '!='
  - 'LIKE'
  - ‘NOT LIKE’
  - 'IN'
  - ‘NOT IN’
  - 'REGEXP'
  - ‘NOT REGEXP’
  - 'RLIKE',
  - 'EXISTS' (alias of '=')
  - ‘NOT EXISTS’ (alias of '!=') Default is 'IN' when $key is an array, '=' otherwise.
- type_key string
  MySQL data type that the meta_key column will be CAST to for comparisons. Accepts 'BINARY' for case-sensitive regular expression comparisons. Default is ''.
- value string|string[]
  Meta value or values to filter by.
- compare string
  MySQL operator used for comparing the $value. Accepts:
  - '=',
  - '!='
  - '>'
  - '>='
  - '<'
  - '<='
  - 'LIKE'
  - ‘NOT LIKE’
  - 'IN'
  - ‘NOT IN’
  - 'BETWEEN'
  - ‘NOT BETWEEN’
  - 'REGEXP'
  - ‘NOT REGEXP’
  - 'RLIKE'
  - 'EXISTS'
  - ‘NOT EXISTS’ Default is 'IN' when $value is an array, '=' otherwise.
- type string
  MySQL data type that the meta_value column will be CAST to for comparisons. Accepts:
  - 'NUMERIC'
  - 'BINARY'
  - 'CHAR'
  - 'DATE'
  - 'DATETIME'
  - 'DECIMAL'
  - 'SIGNED'
  - 'TIME'
  - 'UNSIGNED' Default is 'CHAR'.

Default:false

Source

public function __construct( $meta_query = false ) {
	if ( ! $meta_query ) {
		return;
	}

	if ( isset( $meta_query['relation'] ) && 'OR' === strtoupper( $meta_query['relation'] ) ) {
		$this->relation = 'OR';
	} else {
		$this->relation = 'AND';
	}

	$this->queries = $this->sanitize_query( $meta_query );
}

View all references View on Trac View on GitHub

Uses	Description
WP_Meta_Query::sanitize_query()`wp-includes/class-wp-meta-query.php`	Ensures the ‘meta_query’ argument passed to the class constructor is well-formed.

Used by	Description
WP_Term_Query::get_terms()`wp-includes/class-wp-term-query.php`	Retrieves the query results.
WP_Site_Query::get_sites()`wp-includes/class-wp-site-query.php`	Retrieves a list of sites matching the query vars.
WP_Comment_Query::get_comments()`wp-includes/class-wp-comment-query.php`	Get a list of comments matching the query vars.
WP_Query::get_posts()`wp-includes/class-wp-query.php`	Retrieves an array of posts based on query variables.
WP_User_Query::prepare_query()`wp-includes/class-wp-user-query.php`	Prepares the query variables.
WP_Meta_Query::parse_query_vars()`wp-includes/class-wp-meta-query.php`	Constructs a meta query based on ‘meta_*’ query vars
get_meta_sql()`wp-includes/meta.php`	Given a meta query, generates SQL clauses to be appended to a main query.

Show 2 more Show less

Changelog

Version	Description
5.3.0	Increased the number of operators available to `$compare_key`. Introduced `$type_key`, which enables the `$key` to be cast to a new data type for comparisons.
5.1.0	Introduced `$compare_key` clause parameter, which enables LIKE key matches.
4.2.0	Introduced support for naming query clauses by associative array keys.
3.2.0	Introduced.

WP_Meta_Query::__construct( array $meta_query = false )

In this article

Parameters

Source

Changelog

User Contributed Notes

WP_Meta_Query::__construct( array $meta_query = false )

In this article

Parameters

Source

Related

Changelog

User Contributed Notes