mysql - Read For Learn

How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?

it adds additional value before and after each Like query That {d146fc7cb41ff444163abadd50ac5da7ec5439fd51386c3cfe2cea107126703b} is a placeholder escape string for the literal % (percent) sign used in prepared statements (see wpdb::prepare()) and the escape string is generated by wpdb::placeholder_escape(). So actually, that {d146fc7cb41ff444163abadd50ac5da7ec5439fd51386c3cfe2cea107126703b} is the % sign, but in an escaped form, and it will be changed … Read more

WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)

You should use php 7.4. So verify first it is installed : brew install [email protected] Then with valet : valet use [email protected] then valet restart

Looking for most performant way to execute several similar WP queries within shortcodes

I think, it would be hard to achieve this, on the PHP-side as there is not much to gain in how you execute the WP_Query, because it will still result in the same WP_Queries executing the same logic under the hood. There is however “easy” performance to gain by either; not using WP_Query and for … Read more

Adding new row to wp_post table

First, I assume you’re referring to columns, not rows. To answer your question, no, the upgrade process will not remove the extra columns from the posts table. That said, WordPress has the wp_postmeta table that should be used to store extra data about posts rather than adding columns to the posts table. I would suggest … Read more

Performance on WPMS

Yes, you are long past the point where you need to split the database. 😉

Disallow categories from this MySQL query

You could use the get_tax_sql() function introduced in WP 3.1: $tax_query = array( array( ‘taxonomy’ => ‘category’, ‘terms’ => array( 4, 6, 7, 9 ), ‘operator’ => ‘NOT IN’ ) ); $clauses = get_tax_sql( $tax_query, $wpdb->posts, ‘ID’ ); … “SELECT ID, post_date, post_date_gmt, comment_status, comment_count FROM $wpdb->posts {$clauses[‘join’]} WHERE post_status=”publish” AND post_type=”post” {$clauses[‘where’]} ” … … Read more

Is it possible to split database tables using HyperDB?

HyperDB lets you split whole tables across different databases but it won’t split a single table. You wouldn’t want that anyway because that means wordpress would have to query multiple databases to find a single post. However, depending on how your site is set up, you might be able to work around that by creating … Read more

Within the database, where is the flag which says that a user has Super Admin rights?

This is actually stored in the {prefix}sitemeta table. The meta key is site_admins, and it’s a serialized PHP array of usernames.

Join new table with SQL query

Always escape/prepare your data Don’t leave it open to injections: global $wpdb; $all_posts = $wpdb->get_results( $wpdb->prepare( ” SELECT %s.* FROM %s LEFT JOIN %s ON(%s = %s) WHERE %s=”soundcloud” AND %s=”%s” ” ,$wpdb->posts ,$wpdb->posts ,”{$wpdb->prefix}soundcloud” ,$wpdb->posts.ID ,”{$wpdb->prefix}soundcloud.idpost” ,$wpdb->posts.post_type ,$wpdb->posts.post_name ,$name ), OBJECT ); echo ‘<pre>’.var_export( $all_posts, true ).'</pre>’; Use the prefix $wpdb; offers the $wpdb->prefix, … Read more

How to create and work with custom data / tables (i.e., for arbitrary data)?

WordPress has a pretty flexible way of handling custom data, and it stores it in a table called wp_postmeta (assuming default wp_ prefix). The only catch is that it assumes that it will somehow be related to a certain post, which I’m not sure you actually want to do. It’s very simple to use (see … Read more

+ More