Search Query that Includes Custom Table

I managed to solve this by taking s_ha_dum’s suggestion to use a UNION. It is as follows:

(SELECT ID, post_status, post_title, post_excerpt, post_content FROM wp_posts WHERE ((`post_title` LIKE '%diamond%') OR (`post_excerpt` LIKE '%diamond%') OR (`post_content` LIKE '%diamond%')) AND (`post_status` = 'publish' )) UNION (SELECT ref, StoreID, Article, subarticle, description FROM wp_hwproducts WHERE (`article` LIKE '%diamond%') OR (`subarticle` LIKE '%diamond%') OR (`description` LIKE '%diamond%')) ORDER BY `post_status` DESC;

Related Posts:

  1. Query with search and subscribers only output
  2. How to access custom WordPress database tables
  3. How to print the excuted sql right after its execution
  4. Post_count only shows the number of results per page
  5. Return only Count from a wp_query request?
  6. WP Query where title begins with a specific letter
  7. Search custom taxonomy term by name
  8. Order Search Results Page by meta_value If no Value Return Remaining Results
  9. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  10. Tracing the life of a query
  11. Use WP_Query with a custom SQL query
  12. How to make an activities stream mixing posts and comments?
  13. Pagination not working for Custom search form & custom result template
  14. Pagination broken when merging search results with additional WP_Query
  15. WordPress search exact match
  16. How do I search WordPress by different fields without a plugin?
  17. Multiple keyword search
  18. Looping through tabular data
  19. Using next/previous_posts_link with customised search
  20. WordPress custom search form with pre_get_posts not work
  21. WP Query search for attachments and their exact title
  22. How would I format a query that depends on post parent taxonomy
  23. Mysql query LIKE not working
  24. Modifying the Search Results
  25. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  26. Creating a custom search for a specific post type
  27. Custom Search Result Page displaying only 1 result.
  28. Querying on multiple taxonomies pulled from $_GET checkbox array not working?
  29. Is there any advantage of using default WordPress Search instead of creating a custom one?
  30. WP_Query Not Recognizing Taxonomy Parameter in Custom Search
  31. Search pages that are a child of the current page
  32. Include tags in WP_Query
  33. Search for multiple tags?
  34. Custom Search Not Consistent with Results
  35. Getting post revision and printing them on the post content site
  36. Editing the default wordpress search
  37. How to use wp_query to post count by search term > group post count by date > convert to json. (ex. result 12-21-2020 – 343)
  38. Iterating through $wpdb query without using get_results for large query results
  39. Extend product search with meta in WooCommerce
  40. Search by post id in a specific page then auto-redirect to searched post
  41. wp_Qwery works to slow
  42. Search for “2nd” also returns “22nd” in wp_query
  43. How to query custom post types with mixed AND & OR statements for custom fields
  44. Query most popular terms by taxonomy over 2 week period
  45. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  46. Modify Search Query if original Query gave no results
  47. Is it safe to access the underlying mysqli object from \wpdb for custom queries?
  48. Why Query is returning empty array?
  49. Include post content of linked posts in search
  50. Make a SQL query with wpdb in WordPress
  51. How do I amend wp_query before it is run/executed?
  52. wp_query search not taking keywords with together for multiple words
  53. List of ways to access WordPress database?
  54. Multiple Rows in a using wp_query
  55. Specify strict ‘order by’ in WordPress query
  56. Search Page Returns Nothing
  57. Does WordPress have something like Drupal’s DB API?
  58. How to properly use AND / OR in custom search
  59. How to avoid bypass of search bar rules?
  60. Hide products in uncategorized category from search results
  61. How do you determine if a result in a search query is a post or a page?
  62. wp_query show all values
  63. change posts_orderby of the callback wp_query?
  64. How to restrict search on a certain page to only return results against custom taxonomies?
  65. Ignore image urls in wp_query search
  66. get_var is neither a string, integer, or array …?
  67. What’s wrong with this wpdb query?
  68. WordPress search WP_Query to cover multiple post types and their custom fields?
  69. My combination of ‘post_type’ and ‘tax_query’ not working?
  70. How to prevent WP_Query from filtering on ‘s’ but keep ‘s’ for other purposes?
  71. Add dynamic search to paginated WP_Query
  72. Save queried result into database
  73. Multiple WP_Query args combinations according to post type
  74. Display the search results like the original pages
  75. How to use jQuery validation to set the search bar to accept only a specific input?
  76. WordPress search page pagination displaying but not functional
  77. Search has query that will return no results
  78. WP Query – Search in title or author_name
  79. Limit default Search query to post_title
  80. Order & Orderby clause not working with custom query
  81. How can I modify standard search query to include also ACF custom fields values?
  82. What argument does my function need to echo get_results() query results
  83. Select Unique Posts for a List of Tags
  84. How To Use WP_Query To Get The Custom Post type Posts With Keywords
  85. How to make the default WordPress search return borader results
  86. WordPress WP_Query offset parameter not working with search parameter
  87. Add pagination to table generated by wp_query
  88. Fire query on ajax post url page
  89. Need help setting up a search form for wordpress [duplicate]
  90. Custom search: Search posts but display parent page in results
  91. Query posts by custom fields
  92. Different sql queries count indicator on the main page [closed]
  93. Searching in specific custom post type
  94. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  95. Search (Custom Form, Custom Search Result)
  96. Help with showing text when something is entered in my search bar
  97. Filtering product search results using tags
  98. WordPress WP_Query Search (‘s’) With Multiple Search Terms
  99. Search results stuck on page 1
  100. Custom Taxonomy in custom REST API search