Thanks for the question. This kind of query has not yet been attempted here, so you will be the first to undertake the task!
Please first read the documentation for querying sub field values:
You will need to write some custom SQL to compare between the values, but I’m not entirely sure this can work with a ‘LIKE’ on the meta_name…
Good luck, but this is far beyond the scope of the plugin and I can’t offer too much free support for this one.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We've just released ACF 5.12.3 with a security fix to prevent arbitrary file uploads to forms with ACF fields.— Advanced Custom Fields (@wp_acf) July 14, 2022
Now that we've released this update, we recommend updating your sites as soon as possible.
© 2022 Advanced Custom Fields.