Wp do sql query from function

<?php
// 1st Method - Declaring $wpdb as global and using it to execute an SQL query statement that returns a PHP object
global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Source: developer.wordpress.org

Wp do sql query from function

<?php
// 2nd Method - Utilizing the $GLOBALS superglobal. Does not require global keyword ( but may not be best practice )
$results = $GLOBALS['wpdb']->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Source: developer.wordpress.org

Similar codes

0 vote247 views1 answer
Change date in pivot table to month in sql server
SQL
2 votes203 views1 answer
Create table with primary key
SQL
9 votes227 views3 answers
Mysql run sql file
SQL
3 votes211 views1 answer
Postgres count distinct
SQL
0 vote202 views1 answer
Sql drop procedure if exists
SQL
1 vote322 views1 answer
SQL server query column yes or no
SQL
0 vote202 views1 answer
Restore backupfile discourse
SQL
7 votes218 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
11 votes304 views1 answer
Oracle insert from select
SQL
0 vote188 views1 answer
Calculate date and convert to yearsmysql
SQL