Backticks and regular quotes (both single and double) have distinct meanings in SQL. Quotes indicate a literal string, whereas backticks are quoted identifiers. This isn’t specific to WordPress, but rather a general way in SQL of quoting columns or tables. For example, imagine you’re running a query comparing two columns: SELECT * FROM wp_posts WHERE … Read more
This answer explains what the OP saw with column names and how to work with that, but the real answer is to use get_var() as in Howdy_McGee’s answer. The string you’re seeing is the column name that MySQL is using for the result, because it doesn’t have any better ideas. One way is to give … Read more
See the WordPress Codex on Creating Tables with Plugins.
delete from `wp_terms` where `term_id` in ( SELECT `term_id` FROM `wp_term_taxonomy` WHERE `taxonomy` = ‘post_tag’ ) and `term_id` not like 1 The above Code was exactly what I was looking for.
I wonder if you’re looking for the core attachment_url_to_postid() function that uses: $sql = $wpdb->prepare( “SELECT post_id FROM $wpdb->postmeta WHERE meta_key = ‘_wp_attached_file’ AND meta_value = %s”, $path ); $post_id = $wpdb->get_var( $sql ); Note the extra meta key _wp_attached_file check compared to your current snippet. If you need to check if an image url … Read more
Pretty easy to do from phpMyadmin. I’ve used this tutorial before successfully.
WordPress creating excessive joins on meta_query with search
You could simply use the get_blogs_of_user() function: echo count( get_blogs_of_user( $user_ID ) ); instead of your custom SQL query.
Don’t use $wpdb->prepare with table names. prepare will quote your table names that will result in incorrect SQL. It is unnecessary overhead as well. Your table name should never, and in your case isn’t, be user-supplied data. You have no need to escape it. ‘prepare’ is for use on user-supplied data, such as data from … Read more
Read http://codex.wordpress.org/Moving_WordPress#When_Your_Domain_Name_or_URLs_Change You’ve only moved the PHP files. That is only part of the process. Migrating the databse would mean: Create a database, if there isn’t one already Move the database from your local server to the remote one. Edit/alter key values in the database The same wp-config editing trick used here will get you … Read more