How to find the post id by acf value?

Question

WordPress

Hello, for example, there is an acf field "name" in the records. All records are different.

How to get the id of the entry, or the object of the entry, by the value of "name"?

Answer 1

https://gist.github.com/qstudio/8bc172f60f65aa6f000f
or so

global $wpdb;
$results = $wpdb->get_results( "SELECT post_id  from $wpdb->postmeta WHERE meta_key = 'my_key' AND meta_value = 'my_value'", ARRAY_A );