$wpdb->get_results() returns an index array of row objects, but it looks like you’re expecting $exists to contain the actual value of the used column. you probably want $wpdb->get_var(): http://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Variable
Try this query, remembering to change out your_posts_table with the proper name in your database. Using CONCAT, you can add any number of strings, just pass post_name to add your changes before/after. update your_posts_table set post_name = CONCAT(‘pre-‘, post_name) More info on MySQL CONCAT Note: Use a WHERE clause if you only want to update … Read more
You can try this with WP_User_Query instead: $args = array ( ‘meta_query’ => array( array( ‘key’ => ‘newsletter’, ‘value’ => ‘true’, ), array( ‘key’ => ‘account’, ‘value’ => ‘false’, ), ), ‘date_query’ => array( array( ‘after’ => ‘2015-01-13 00:00:00’, ‘inclusive’ => true, ), ), ); $user_query = new WP_User_Query( $args ); where I assume your … Read more
User Meta Query with RLIKE: If the birth date is stored like dd/mm/yyyy, in the user meta, then you could find all August birthday users with the following meta query: ‘meta_query’ => [ [ ‘key’ => ‘birthday’, ‘value’ => ‘/08/’, ‘compare’ => ‘RLIKE’ ], ] You could also consider storing the birthday month additionally in … Read more
I am not sure where you got that export code but I don’t see the PRIMARY KEY defined as it should be. Take a look at the code from Core that creates the table: 87 CREATE TABLE $wpdb->commentmeta ( 88 meta_id bigint(20) unsigned NOT NULL auto_increment, 89 comment_id bigint(20) unsigned NOT NULL default ‘0’, 90 … Read more
First of all there is no such thing as WordPress Database in this context. You can use WordPress with MySQL/MariaDB. You can use MySQL/MariaDB that wordpress uses to store your data. The size of your data is not a problem. The performance is not so straightforward to decide. I think MySQL will come close or … Read more
The sticky posts info is stored in the sticky_posts option in the options table. It’s stored as serialized array e.g. a:2:{i:0;i:1272;i:1;i:1995;} You can modify it via the Options API but there’s a way to bulk edit posts in the backend: 1. Select the Sticky view: 2. Select all sticky posts and apply the bulk Edit … Read more
You can do that with a command in your database: UPDATE `wp_posts` /* Adjust the prefix! */ SET `post_title` = CONCAT( UCASE( /* First letter uppercase */ SUBSTRING( `post_title`, 1, 1 ) ), ”, LCASE( /* The rest in lowercase */ SUBSTRING( `post_title`, 2, LENGTH(`post_title`) ) ) ); If your author has a habit of … Read more
This is the way WordPress does it: SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘custom_field’ ) WHERE wp_postmeta.post_id IS NULL You can do this with WP_Query meta_query and ‘compare’ => ‘NOT EXISTS’.
I’ve found an answer by myself.. (sample code) $args_array = array($post_type); $term_slugs = array(‘foto’, ‘video’); // create a string like ‘%s, %s’ ecc $placeholders = implode(‘, ‘, array_fill(0, count($term_slugs), “%s”)); $term_query = “t.slug IN ($placeholders) “; $args_array = array_merge($args_array, $term_slugs); $ids = $wpdb->get_results($wpdb->prepare(” SELECT m.meta_value FROM ” . $wpdb->prefix . “posts p INNER JOIN ” … Read more