WordPress at a glance

Category: SQL 6

dbDelta()

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

esc_sql()

Escapes data for use in a MySQL query.

get_meta_sql()

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

get_num_queries()

Retrieve the number of database queries during the WordPress execution.

get_posts_by_author_sql()

Retrieve the post SQL based on capability, author, and type.

sanitize_sql_orderby()

Ensures a string is a valid SQL 'order by' clause.