WP_Meta_Query::__construct( array $meta_query = false )

Constructor.

Contents

Parameters

$meta_query array Optional
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

Top ↑

Source

File: wp-includes/class-wp-meta-query.php. View all references 

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 on Trac View on GitHub

Top ↑

Top ↑

Used By

Used By
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 used by Hide more used by

Top ↑

Changelog

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.

Top ↑

User Contributed Notes

You must log in before being able to contribute a note or feedback.