Complete Database search query

Question

My web Application need to integrate the search button same like google search,In these search button i need to search complete database for these matching string.

How to write a query for these issue because i need to write in where clause multiple tables of the database to get that string record.