$wpdb and SQL in WordPress

$wpdb and SQL in WordPress — a practical guide to WordPress $wpdb prepare with clear examples you can reuse in real projects.

SQL Tutorial Series (96/100). Prefer one article? Read the complete SQL tutorial.

Short description

Escaping with prepare is mandatory for any interpolated values.

$wpdb prepare

global $wpdb;
$row = $wpdb->get_row(
  $wpdb->prepare("SELECT ID, user_email FROM {$wpdb->users} WHERE ID = %d", $user_id)
);