I am not sure why you are creating a UNIQUE constraint for your “ID”, which can be a primary key. Also, please note that the dbDelta fails in certain versions of MariaDB when you create a table with a Unique Key Index or a Composite Key or any other indexes except the Primary Key. The … Read more
You can get a post row by the ID global $wpdb; $mylink = $wpdb->get_row( “SELECT * FROM $wpdb->posts WHERE ID = 10” );
WordPress database error: You have an error in your SQL syntax
I wouldn’t use taxonomies or custom fields for this purpose. Every time you’re add one custom field for a query, you have to add a JOIN part for that query – it means that with 10-15 custom fields, you’ll get query with 10-15 joins – so such query will be very slow. But there is … Read more
I’ve figured out a fix. First, to fix bad results for an empty search, I require that (!empty(get_query_var(‘s’)) Before setting the “meta_query” query variable in my plugin. I thought the fix would be with the posts_request filter, but it continued to replace select SQL_CALC_GET_ROWS wp_posts.ID with select SQL_CALC_GET_ROWS wp_posts.* Even when I replaced the * … Read more
figured it out. I spent literally days trying different code and the answer was under my nose. Lack of sleep! replace “INSERT” with “REPLACE” any tips for removing a category?
Meta Queries are nested arrays. See the WP_Query section on meta queries. Option 1 Use meta_key and meta_value directly in the query arguments, not as a meta query. $student_query_args = [ ‘post_type’ => ‘student_list’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => 100, ‘order’ => ‘DESC’, ‘meta_key’ => ‘program_id’, ‘meta_value’ => 5317, ]; Option 2 The meta query … Read more
WP Query related posts by tags
How do I run SQL queries on a WordPress web page? [closed]
There are lots of ways to get all IDs. Assuming you do want all posts – which include Posts, Pages, Media, Menu Items, custom post types, etc.: phpMyAdmin: Run a SQL query: SELECT ID FROM wp_posts then export the results to whatever file type you prefer.