W3cubDocs

/WordPress

get_meta_sql( array $meta_query, string $type, string $primary_table, string $primary_id_column, object $context = null ): string[]|false

Given a meta query, generates SQL clauses to be appended to a main query.

Description

See also

Parameters

$meta_queryarrayrequired
A meta query.
$typestringrequired
Type of meta.
$primary_tablestringrequired
Primary database table name.
$primary_id_columnstringrequired
Primary ID column name.
$contextobjectoptional
The main query object.

Default:null

Return

string[]|false Array containing JOIN and WHERE SQL clauses to append to the main query, or false if no table exists for the requested meta type.
  • join string
    SQL fragment to append to the main JOIN clause.
  • where string
    SQL fragment to append to the main WHERE clause.

Source

function get_meta_sql( $meta_query, $type, $primary_table, $primary_id_column, $context = null ) {
	$meta_query_obj = new WP_Meta_Query( $meta_query );
	return $meta_query_obj->get_sql( $type, $primary_table, $primary_id_column, $context );
}

Changelog

Version Description
3.2.0 Introduced.

© 2003–2024 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/get_meta_sql