This is a really interesting question, which can result in a very expensive, resource intensive process which can really slow your page down dramatically PRELUDE All my code in this question is based on the following post type and taxonomy, so before you run any code, make sure to adjust the post type and taxonomy … Read more
First add define(‘WP_SITEURL’, ‘http://example.com’); define(‘WP_HOME’, ‘http://example.com’); To your wp-config.php file (obviously change example.com to your domain) then login and once you see the admin panel navigate to http://yoursite/wp-admin/options.php there you can change home and siteurl to your new domain and save. You will also need to change the links for images and other media in … Read more
You will need to join four tables to get categories of custom post type “review” wp_term_relationships wp_posts wp_term_taxonomy wp_terms by using following query you can get list of categories applied to your custom post type: SELECT * FROM wp_term_relationships AS tr LEFT JOIN wp_posts AS p ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt … Read more
The WordPress database is already indexed. See this codex article for a detailed list of indexes per table: http://codex.wordpress.org/Database_Description And even if it weren’t, you’d need to know what queries are being run in order to effectively add indexes. Meaning, there would be no quick fix–you’d have to learn how indexing works, figure out what … Read more
If you mean post type instead of slug I’d say… UPDATE wp_posts SET post_status=”archived” WHERE post_status <> ‘static’ AND post_type=”cpt_operator”; But be careful when editing the db directly!
Hector’s answer works well, but if you have have a large number of users you need to remove (in my case, it was over 13,000 spam registrations) I find using this little utility script works wonders, and doesn’t require you to manually check and delete from the user-list in the admin panel. The script still … Read more
Hi @Holidaymaine: Here’s the query you are looking for: <?php include( ‘../wp-load.php’ ); $sql =<<<SQL SELECT DISTINCT u.user_email AS user_email, um.meta_value AS user_lastname FROM {$wpdb->users} AS u LEFT JOIN {$wpdb->usermeta} AS um ON u.ID = um.user_id LEFT JOIN {$wpdb->posts} AS p ON u.ID = p.post_author LEFT JOIN {$wpdb->term_relationships} AS tr ON p.ID = tr.object_id LEFT … Read more
SQL query equivalent to WP User Query
For SQL, the post’s content is saved in “wp_posts” table under “post_content” column. When doing this from phpmyadmin, you’ll have to take care that you’re updating only the main post & not one of it’s revisions If you’re looking for some wordpress based solution, the wordpress way to do it is to use wp_update_post // … Read more
I do this all the time to move a site from our staging server to the live domain. I use PHPMyAdmin to export the database as an SQL file, then open it up in a text editor and do a global find and replace on the old url to change it to the new url. … Read more