Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]

Question

I'm currently facing a little problem. I'm using ACF plugin which generate complex meta_key names when creating hierarchical fields.

I found in my database meta_key named modules_1_content_0_module.

I want to be able to retrieve all the posts which have a meta_key which finish with _module and where meta_value is a given id.

Is it possible to do that directly with the WP_Query API ?

Thanks

Answer 1

There is an interesting answer on SO which present different methods to resolve that issue: How do I query for posts by partial meta key?

• By custom SQL query (in my project I've used that solution)
• By changing the meta schema to store the dynamic meta_key as a meta_value
• By using the posts_where filter to update query behaviour based on input