WordPress Themes Developer Interview Question:

Explain me how to run database Query in WordPress?

Submitted by: Muhammad

The $wpdb->query function allows you to execute any SQL query on the WordPress database. It is best to use a more specific function. Check sample code below for SELECT query.

<?php $wpdb->query('query'); ?>// Examples

$wpdb->query( "

UPDATE $wpdb->posts

SET post_parent = 7

WHERE ID = 15

AND post_status = 'static' "

);
Submitted by: Muhammad