New answers tagged

2

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 better in most of the time. Also you will not be ...


0

I always find it way less confusing to get the results from one table and loop them rather than to try to join them like that... eg. global $wpdb; $query = "SELECT post_id FROM wp_postmeta WHERE meta_key='fake_author' AND meta_value='11111'"; $results = $wpdb->get_results($query); foreach ($results as $result) { $query = "UPDATE wp_posts SET ...



Top 50 recent answers are included