How to Run MySQL Queries in WordPress

At some point in your WordPress development career you may be presented with the need to write some custom mysql queries but how to do? don’t worry i write basic MySQL queries these may help you.

WordPress MySQL Select Query

How to fetch single row in WordPress

$ures = $wpdb->get_row("SELECT * FROM `custome_users` ORDER BY `id` DESC");
$ures ->name;

How to fetch multiple rows in WordPress

$ures = $wpdb->get_results("SELECT * FROM `custome_users` ORDER BY `id` DESC");					
foreach ($ures as $uresfet)
{
    $uresfet->name;
}

How to count total number of rows in WordPress

 $ures = $wpdb->get_results("SELECT * FROM `custome_users` ORDER BY `id` DESC");
 $rows=$wpdb->num_rows;

How to delete row from table using MySQL query in WordPress

 $wpdb->query("DELETE FROM custome_users where id='$deleteid'");

How to update data into database using MySQL query in WordPress

 $wpdb->query("UPDATE `sample_requests` SET `firstname` = '$firstname', `lastname` = '$lastname' WHERE `id` ='$id'");