grexican

<p>If you’ve ever needed your ACF choices to be dynamically generated by a SQL query, this plugin will help you get the job done.</p>
<p>You can mix and match static choices with dynamic, SQL-based choices by placing as many regular choices in the list as you’d like, followed by the special <code>%%QUERY%%</code> choice that will tell this plugin to load choices dynamically from the database.</p>
<p>An example on how to list users, setting the <code>id</code> as the value, would look like this:</p>
<pre><code>%%QUERY%% : SELECT user_nicename AS text, id AS value FROM wp_users
</code></pre>
<h3>Arbitrary section</h3>


ACF Dynamic Choices

Advanced Custom Fields plugin to allow for dynamic choices (through SQL queries)

it2911

<p>TiDB is a high-performance database that is compatible with the MySQL protocol. Since MySQL has deprecated the SQL_CALC_FOUND_ROWS function, TiDB also has no intention of offering the SQL_CALC_FOUND_ROWS function. This leads to an error in WordPress when using TiDB, indicating that SQL_CALC_FOUND_ROWS is not supported, and submissions cannot be displayed correctly.</p>
<p>WordPress is also currently working on this issue, but it seems that more time is needed. #47280 Remove usage of deprecated MySQL SQL_CALC_FOUND_ROWS from WP_Query</p>
<p>This plugin solves the issue of TiDB not providing the SQL_CALC_FOUND_ROWS function. Once this plugin is activated, parts of WP_Query that use SQL_CALC_FOUND_ROWS will be replaced with the COUNT(*) function.</p>
<p>This plugin is entirely based on the method mentioned by @akramipro in the article, and this solution works perfectly and addresses the issue. I’ve turned this method into a plugin so that those using TiDB can easily resolve this problem. Many thanks to @akramipro for the excellent work, and I hope the official WordPress team can address this issue sooner.</p>
<h3>Contribute</h3>
<p>Contribute to this plugin on <a href="https://github.com/pingcap/wordpress-tidb-plugin" rel="nofollow ugc">github.com/pingcap/wordpress-tidb-plugin</a></p>


TiDB Compatibility


This plugin is a must-have if you are running TiDB as the database instead of MySQL/MariaDB.


Must have for TiDB users

This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.

ACF Dynamic Choices vs TiDB Compatibility