get_meta_sql() WordPress Function
The get_meta_sql() function is used to generate SQL code for retrieving post meta data from the database. This function is used internally by the Wordpress database abstraction layer to generate SQL queries.
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
(array)(Required)A meta query.
- $type
(string)(Required)Type of meta.
- $primary_table
(string)(Required)Primary database table name.
- $primary_id_column
(string)(Required)Primary ID column name.
- $context
(object)(Optional) The main query object
Default value: null
Return
(array) Associative array of JOIN and WHERE SQL.
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 full source codeCollapse full source codeView on TracView on GitHub
Changelog
| Version | Description |
|---|---|
| 3.2.0 | Introduced. |