get_meta_sql( array $meta_query, string $type, string $primary_table, string $primary_id_column, object $context = null )

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

Description

See also

Parameters

$meta_query

(Required) A meta query.

$type

(Required) Type of meta.

$primary_table

(Required) Primary database table name.

$primary_id_column

(Required) Primary ID column name.

$context

(Optional) The main query object.

Default value: 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.<br>

  • 'join'
    (string) SQL fragment to append to the main JOIN clause.<br>
  • 'where'
    (string) SQL fragment to append to the main WHERE clause.<br>

Source

File: wp-includes/meta.php 

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 );
}

Expand Source Code View on GitHub

Changelog

Changelog
Version Description
3.2.0 Introduced.