I need the search for highly customized. I've a custom post type with custom field. Search result should be displayed in this way:
- First search should be performed into all title and displayed them
- Then into a custom field and shown then (except those which were shown in step 1)
So, I planned about using fully custom MySQL query. I'll search inside title first and store post ids into an array. Then run another query into post meta table and show result except those posts which were shown in first step based on the array of post id.
Don't know if it's a good idea. Can you please give me an idea to perform my task in an effective way?