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 vote293 views1 answer
How to select only a certain date sql
SQL
0 vote296 views1 answer
Mysql last friday of current month
SQL
0 vote296 views1 answer
Get primary key of table
SQL
1 vote287 views2 answers
Sql server find all foreign keys that reference a column
SQL
8 votes263 views1 answer
Oracle add month
SQL
1 vote324 views1 answer
Mysql default port
SQL
0 vote296 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
8 votes309 views2 answers
Update sql server from another table
SQL
0 vote273 views2 answers
How to get last inserted id in sql server c#
SQL
-1 vote276 views1 answer
Sql oracle take only last results
SQL