Gladly I’ve written two plugins for that yesterday: Filter/Core That’s what a search query part looks like inside the posts_search filter: ‘ AND (((wp_XX_posts.post_title LIKE ‘%test%’) OR (wp_XX_posts.post_content LIKE ‘%test%’))) ‘ where wp_XX_ is just the $wpdb->prefix for my WPSE test site inside my local MU installation. Plugin #1 – drop searching post types that … Read more
This is what I’ve found. I’m using a filter to filter the ORDER BY on the SQL query generated by WP_Query. The filter is this posts_orderby. And with it, you can write a custom ORDER BY for the query. I’m gonna show you an example. add_filter(‘posts_orderby’, ‘posts_orderby’); function posts_orderby($orderby_for_query) { $orderby_for_query = “LEFT(wp_posts.post_date, 10) DESC, … Read more
Add flush_rewrite_rules(); to your theme’s functions.php, load the page, and them remove it. It is very inefficient to have that run on every page load. Hopefully your edits to the options table are sane. If not, that will not work. Caveat: I think that functions.php is adequate. You may need to add it to a … Read more
In the question you linked to, the solution was to use mysqli_multi_query as the API for executing the SQL. $wpdb desen’t have an API to do a multi query therefor you can’t use it directly, but you can get the handle to the mysql interface from $wpdb->dbh and do something like $sql_trigger = “….”; mysqli_multi_query($wpdb->dbh,$sql_trigger);
Thanks to @AhmedMahdi’s comment I figured out the following works for my situation: select * from wp_posts where post_status=”publish” order by post_modified desc; The where condition is necessary to remove all the draft or private posts that I am not concerned with.
WordPress actually specifies no table type in the create statements, so it uses MySQL’s default table engine which is InnoDB from version 5.5 onwards.
You should be fine deleting empty custom fields. The main reason is, that get_post_meta( $id, ‘metakey’, true ) returns an empty string if the field is not set, so it is the same as having an empty record set. get_post_meta( $id, ‘metakey’, false ), returns an empty array if no value is set, so you … Read more
Strictly from a MySQL Point-of-View SHORT VERSION MyISAM Storage Engine Table locks Writes are first come, first serve Reads slow down writes from initiating InnoDB Storage Engine Row locks Transactions (non blocking) Deadlock may occur when updating indexes LONG VERSION If the underlying tables use the MyISAM Storage Engine, row locks are not possible. Each … Read more
What you’re talking about is a database fallback. It’s possible to set something like this up, but not directly with WordPress. How it would work Instead of accessing the database directly, you’d access a proxy. This proxy would sit in front of both your primary and backup databases and pass traffic through. Essentially, it would … Read more
I’ve read that dumping the database as text and searching in it is a good way to go. You can search with phpmyadmin, but it’s limited. Depends on the size of the database and a good text editor, but you can delete post/page revisions before dumping the database to bring it down in size. Or … Read more