Skip to content
Advertisement

meta_query, how to search using both relation OR & AND?

Resolved: See answer below.


I have a custom post type called BOOKS. It has several custom fields, named: TITLE, AUTHOR, GENRE, RATING. How do I fix my meta_query code below so that only books that have the search word in the custom fields: title, author, genre WITH EXACTLY the rating specified in my search form, gets displayed in the results?

I have made a custom search form; a text area that will search through the title, author and genre; and a dropdown that will search for the rating. The meta_query I made below only searches through the title, author, and genre. But I am now stumped in how to add the code for the rating.

This is how I visually imagined it with meta_query relation: (title OR author OR genre) AND rating

I would extremely appreciate your help and advice.

Advertisement

Answer

I found the solution with some help. The code below worked perfectly.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement