WordPress at Your Fingertips

sql (tag)

dbDelta()

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

get_meta_sql()

Given a meta query, generates SQL clauses to be appended to a 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.