WordPress at a glance
Home Functions Other Functions SQL

SQL (category)

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. Protects against SQL injections. May accept an array of strings for processing.

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()

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

sanitize_sql_orderby()

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