I have a simple SQL query: SELECT * FROM test_table__csv_import_temp_joblist WHERE url =''
In phpMyAdmin, it works well and returns a result. In WP it returns nothing:
$sql = "SELECT * FROM test_table__csv_import_temp_joblist WHERE url =''";
$res = $wpdb->query( $sql );
What is the issue with my query?
$wpdb->last_query returns the right query.
$wpdb->last_error returns nothing.
Many Thanks
I have a simple SQL query: SELECT * FROM test_table__csv_import_temp_joblist WHERE url ='https://www.example'
In phpMyAdmin, it works well and returns a result. In WP it returns nothing:
$sql = "SELECT * FROM test_table__csv_import_temp_joblist WHERE url ='https://www.example'";
$res = $wpdb->query( $sql );
What is the issue with my query?
$wpdb->last_query returns the right query.
$wpdb->last_error returns nothing.
Many Thanks
Share Improve this question asked Jan 15, 2019 at 15:14 user998163user998163 3137 silver badges15 bronze badges 1- Are you certain that this table is in the same database as the one WordPress is using? – Jacob Peattie Commented Jan 15, 2019 at 15:26
1 Answer
Reset to default 0Your problem is that you use query method of wpdb and if you read it’s docs:
The query function allows you to execute any SQL query on the WordPress database. It is best used when there is a need for specific, custom, or otherwise complex SQL queries. For more basic queries, such as selecting information from a table, see the other
wpdbfunctions above such asget_results, get_var, get_row or get_col.query (string) The SQL query you wish to execute. This function returns an integer value indicating the number of rows affected/selected for
SELECT, INSERT, DELETE, UPDATE, etc. ForCREATE,ALTER, TRUNCATEandDROP SQLstatements, (which affect whole tables instead of specific rows) this function returns TRUE on success. If a MySQL error is encountered, the function will return FALSE. Note that since both 0 and FALSE may be returned for row queries, you should be careful when checking the return value. Use the identity operator (===) to check for errors (e.g.,false === $result), and whether any rows were affected (e.g.,0 === $result).
You’ll see that it’s not what you want.
If you want to get results of the query, you should use get_results method:
$res = $wpdb->get_results( $sql );