title: Implement custom search by term name(s) in wordpress
body: <p>I have implemented normal search functionality in simple pages using php and MySQL where I get result rows by mysqli_fetch_array. There I could have any numbers of variable with AND or OR relationship and it will retrieve results from the db.
  Now I am trying to do this in WordPress.
  I have seen solutions where one uses WP_query to search by term names. How do I achieve this AND and OR variables in my search query.</p>
  
  <p>For example, my query is like select all post title where term name like 'search keyword' AND term slug like 'hi'.</p>
  
  <p>I have created a view terms_and_posts table from merging terms and posts tables using taxonomy relationship, with columns custom term name, custom term slug, post title, post content, post status, and post type.</p>
  
  <p>Do I need a merged table or it can be achieved by modifying WP_Query?</p>
  
  <p>I do not want to resort to using plugins as I am very new to WordPress, and I prefer not to use plugins as long as I can help it.</p>