How do I search within DATABASE.. as Google searches within the HTML pages.. like we write anything and get the result.. same I want a search type for DATABASE..
So from where I should start or what procedure should be followed..

You would need to write a query. Another method is to create a table that contains whay you want to search for. For example:

tblSearch
SearchID (PK)
TableID (FK)
FieldID (FK)
RecordID (FK)
Value

You can then add a record in that table for each field you want to search on identifying the table, field and record for the value. You can then search for the value, capture the table ad record info and use that to find the record.

You need to write a query for e.g SQL with a statement like Select name from table where name=sourabhpace;

To get further exposure visit this website >>