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

1 vote342 views3 answers
How to truncate table with foreign key constraint
SQL
23 votes310 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote321 views1 answer
Sql server remove 0 from left
SQL
1 vote506 views1 answer
Postgres upgrade to superuser
SQL
4 votes342 views6 answers
Sql select statement
SQL
0 vote304 views1 answer
Full syntax inner join
SQL
0 vote335 views1 answer
Mysql subdate
SQL
0 vote330 views1 answer
Set a value by excuting stored procedure
SQL
4 votes298 views2 answers
Select todays data postgres query
SQL
0 vote335 views2 answers
Create fulltext index mysql
SQL