sql (tag)

dbDelta()

Creates or modifies database tables based on the specified SQL query to create table.

get_meta_sql()

Creates the JOIN and WHERE parts of the SQL query for metadata based on the provided parameters, which can be used in the main query.

get_posts_by_author_sql()

Retrieves WHERE part of the SQL query where posts with 'private' post status for authenticated users will be taken into account.

wc_get_product_id_by_sku()

Gets product ID by its SKU number.

WP_Date_Query{}

Class for creating the WHERE part of an SQL query. Creates a part of the query related to date selection.

WP_Tax_Query{}

The class creates the JOIN and WHERE parts of the SQL query, which, in addition to the main query, will filter the result by the specified terms (taxonomy elements).