Skip to main content
1 vote
Accepted

Combining two select posts from mysql - to get least viewed posts

This should be the SQL you're looking for (off the top of my head, so may need some tweaking). "SELECT * FROM wp_posts LEFT JOIN wp_popularpostsdata ON (wp_posts.ID = wp_popularpostsdata.postid) ...
Chris Cox's user avatar
  • 1,546
1 vote

Find specific text in the database and display the context of where that text is

For this I suggest you to use Search and Replace plugin which has Dry Run option under Tools > Search & Replace > Search & Replace, here we need to check the Dry Run checkbox. In Dry Run ...
Narendra Sishodiya's user avatar
1 vote
Accepted

$wpdb->update is not working until next page refresh. Is there one more step?

When you use $wpdb->update in WordPress, it updates the database immediately, but WordPress might still show cached data. To ensure the updated data is displayed right away, you should manually ...
mukto90's user avatar
  • 1,607

Only top scored, non community-wiki answers of a minimum length are eligible