Search: how to extend the existing search to include a custom table

By default, WordPress searches by keyword. What this means is that when passed the search query “Loren Ipsum”,
WordPress builds the following for the WHERE clause:

((wp_posts.post_title LIKE '%Loren%') OR
(wp_posts.post_content LIKE '%Loren%')) 
AND
((wp_posts.post_title LIKE '%Ipsum%') OR
(wp_posts.post_content LIKE '%Ipsum%'))

This answer can be helpful to you !
There is also a plugin for this : Search Everything

Related Posts:

  1. Is it ever okay to include inline CSS in plugins?
  2. How can I configure Docker for developing and deploying a custom theme?
  3. No Error Log File, no debug info
  4. Is the new WordPress 3.1 admin bar pluggable and how can I extend it?
  5. Getting a peer review for my new plugin?
  6. Using filters and actions for plugin API?
  7. How to add multiple custom URL variables?
  8. How to Change the Entire WordPress Admin panel Look and Feel?
  9. Getting wrong relationship value in $args in wp_Query?
  10. Why Does get_posts() Return an Empty Set?
  11. Allowing for multiple template views on the Gallery Settings page when using the Visual Editor
  12. Using Primary Color in Plugin Block
  13. How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
  14. When is it appropriate to put functions on page template vs. functions.php?
  15. add_filter and remove_filter added before and after wp_query
  16. How to get all images and their thumbnails from wp media library
  17. How to create a dynamic page based on form data with a plugin?
  18. How to use wp_set_password in a plugin?
  19. How to Display Custom Post Type’s Gallery (images ) in Through WP_Query
  20. Handling form request from plugin file
  21. Delete a specific item menu when I deactivate my plugin
  22. Are we allowed to use the Allman (BSD) indent style when coding WordPress plugins and themes?
  23. How to get orders with used coupon in WooCommerce
  24. Get the password key when using the wp_new_user_notification_email filter
  25. How to print raw query from WP_Query class just like in CodeIgniter
  26. Order properties should not be accessed directly
  27. WP_Query returns no results
  28. Finding posts containing matching array elements in a meta field usign WP_Query
  29. How to deal with equal & similar arguments for a function?
  30. Create a custom display order in the main menu
  31. Executing a function upon webhook calling wordpress
  32. Customizer: widget-synced triggers twice
  33. WordPress not working on localhost
  34. manage_posts_custom_column, showing serial number using increment in loop
  35. Adding functions to hooks from within a class
  36. how to use hook deleted_user into custom function to delete user from custom table
  37. Where to store the name of a custom table?
  38. WordPress is automatically linking plain text email addresses
  39. Is Using WordPress Supplied WYSIWYG Advisable?
  40. ServerSideRender and Media Object: attributes passing image data object to php renderer even though it’s not set
  41. Slow WP_query due to nested wp_query. Need Suggestions
  42. Clearing caches on plugin uninstall
  43. How to use a hook to override an update_post_meta call in a plugin?
  44. How can we display product price $104 on the cart while the credit card payment method is checked?
  45. How to fetch only current hour posts?
  46. Is there documentation reference for forms in menu and setting pages?
  47. Enqueue script globally
  48. How to modify files inside wp-includes directory in wordpress
  49. How I can use order by of the custom post title?
  50. Custom entity search and display
  51. How to set a cookie for logged in users to md5($user->ID . “my_secret”)?
  52. Plugin: database creation
  53. Loading Modernizr (or other JavaScript libraries) for use in a plugin
  54. Create Widget or Enable Shortcodes in Sidebar
  55. Store custom meta box data as serialized array
  56. Logout after clicking URL link results in “headers already sent” error
  57. How remove trashed WooCommerce orders from wc_get_orders() result?
  58. How to use a WP_Customize_Control outside of the Customizer?
  59. Get post thumbnail in WP_Query
  60. Pagination not working with custom wp_query
  61. Get Posts by IDs (optionally)
  62. Setting a post’s category
  63. Extract Information from post content (using regex?)
  64. Customise Grouped Product display in Woocommerce with custom column
  65. Custom Endpoint – Does it possible to use PUT method with WP API Rest?
  66. Why won’t this submenu page show? – My First WordPress Plugin
  67. Multiple dynamic Tax Query – pass taxonomy argument from array
  68. WP_Query not ordering correctly
  69. Metabox types list
  70. Where to save Gutenberg plugin data?
  71. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  72. Rate limiting ajax requests in WordPress
  73. Does hooking into a plugin action / filter override the plugin’s function for that hook?
  74. User meta query using Wildcard
  75. WP Query date_query with several date range
  76. How to prevent users from deleting their accounts?
  77. Hiding class namespace from plugin’s extensions
  78. Set widget icon in Customizer?
  79. Determine if the current page, is being edited
  80. WordPress delete mysql rows with string
  81. Add function to Dokan ajax class
  82. PHP includes with AJAX actions
  83. Post Pagination does not working on WP-Query
  84. WP Query Relations / Compare
  85. How can I query 3 posts from diferente categories (one of each category)
  86. Custom Post Type and Functions
  87. Associating special meaning with user id 0
  88. Theming Custom Plugin Page
  89. Best practice: What belongs in theme and what in plugin for large eCommerce website
  90. Adding class to the parent of current-post-ancestor / current-menu-parent / current-post-parent
  91. Dynamic banner for use on external sites
  92. Can’t get query string in ajax call
  93. Adding Meta box to thrid-party plugin
  94. How do I store a custom dataset in WordPress to best take advantage of API?
  95. Is Explicit Versioning a better alternative to Semantic Versioning for wordpress?
  96. Custom plugin not appearing
  97. Return custom product in ajax call loop
  98. Is there any other ways to replicating changes on live from staging without pushing from git
  99. Can I log the searches that are returning 404 in the DB?
  100. Developing an IP lookup function using an API