mysql

SQL query to delete users with multiple meta keys and comments

So i got the answer and solution here https://stackoverflow.com/questions/55142768/sql-for-wp-to-delete-users-with-multiple-meta-keys-and-comments/55142835#55142835 SELECT u.* FROM wp_users u WHERE NOT EXISTS (SELECT 1 FROM wp_usermeta um WHERE u.ID = um.user_id AND um.meta_key IN (‘metakey1’, ‘metakey2’) ) AND NOT EXISTS (SELECT 1 FROM wp_comments c WHERE u.ID = c.user_id );

Error inserting into custom table – Object of class wpdb could not be converted to string [closed]

$wpdb->$table_name is not a valid table name. Use $table_name $wpdb->query( $wpdb->prepare( ” INSERT INTO $wpdb->$table_name ( first_name, last_name, email,telephone,user_name) VALUES ( %s, %s, %s,%s,%s ) “, $first_name,$last_name,$email,$telephone,$current_username ) ); should be $wpdb->query( $wpdb->prepare( ” INSERT INTO $table_name ( first_name, last_name, email,telephone,user_name) VALUES ( %s, %s, %s,%s,%s ) “, $first_name,$last_name,$email,$telephone,$current_username ) );

I would like some help wth an SQL query to link posts with categories

You need to JOIN the term tables with the posts table, something like this: SELECT p.post_name, p.post_content, t.name FROM wp_posts p JOIN wp_term_relationships tr ON ( tr.object_id = p.ID ) JOIN wp_term_taxonomy tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id ) JOIN wp_terms t ON ( t.term_id = tt.term_id ) WHERE p.post_type=”post” AND p.post_status=”publish” AND tt.taxonomy = … Read more

Change upload URL by mime type

It turns out the value that points to the PDFs’ locations on disk is stored in the wp_postmeta table, under the meta_value field. For example a media item located at site.com/app/uploads/2019/06/whatever.pdf would have a meta_value value of 2019/06/whatever.pdf. To change the location of all PDFs I first found the IDs of all PDFs (from the … Read more

+ More