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