This page redirects to an external site: https://developer.wordpress.org/reference/functions/get_meta_sql/

Description

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

Usage

<code style="color: #000000"><span style="color: #0000BB"><?php get_meta_sql</span><span style="color: #007700">( </span><span style="color: #0000BB">$meta_query</span><span style="color: #007700">, </span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$primary_table</span><span style="color: #007700">, </span><span style="color: #0000BB">$primary_id_column</span><span style="color: #007700">, </span><span style="color: #0000BB">$context </span><span style="color: #007700">); </span><span style="color: #0000BB">?></span></code>

Parameters

$meta_query

(array) (required) A meta query.

Default: None

$type

(string) (required) Type of meta.

Default: None

$primary_table

(string) (required) Database table you want to append the query to.

Default: None

$primary_id_column

(string) (required) Database table primary id column.

Default: None

$context

(object) (optional) The main query object.

Default:

Return Values

(array) array( 'join' => $join_sql, 'where' => $where_sql ).

Examples

<?php  
$meta_query = array(
	array(
		'key' => 'color',
		'value' => 'blue',
		'compare' => 'NOT LIKE'
	)
);
global $wpdb;
$meta_sql = get_meta_sql( $meta_query, 'post', $wpdb->posts, 'ID' );

Output depending on the meta query:

Array
(
    [join] =>  INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
    [where] =>  AND ( (wp_postmeta.meta_key = 'color' AND CAST(wp_postmeta.meta_value AS CHAR) NOT LIKE '%blue%') )
)

Change Log

Since: 3.2.0

Source File

get_meta_sql() is located in wp-includes/meta.php.

Related