WordPress at Your Fingertips

wpdb (tag)

maybe_convert_table_to_utf8mb4()

If a table only contains utf8 or utf8mb4 columns, convert it to utf8mb4.

wpdb::delete()

Deletes a row in the table.

wpdb::esc_like()

First half of escaping for LIKE special characters % and _ before preparing for MySQL.

wpdb::get_col()

Retrieves one column from the database.

wpdb::get_col_info()

Retrieves column metadata from the last query.

wpdb::get_results()

Retrieves an entire SQL result set from the database (i.e., many rows).

wpdb::get_row()

Retrieves one row from the database.

wpdb::get_var()

Retrieves one variable from the database.

wpdb::insert()

Inserts a row into the table.

wpdb::prepare()

Prepares a SQL query for safe execution.

wpdb::query()

Performs a MySQL database query, using current database connection.

wpdb::replace()

Replaces a row in the table.

wpdb::update()

Updates the specified data in the specified row of the DB table.