How to apply Search functionality for all the content types?

Questions and Answers Database-SQL
2

@debashis.qba ,
More control over search logic and data handling. Requires more development effort to build and maintain the custom API.