It´s really hard to know what you mean.
If you have only one database and you are searching a table you can do this in sqlquery.
if you use MS sql, then you can do it like this example.
Select * from Persons where Name like '%'+@searchstringparam+'%'
Where Persons is tablename, Name is Columnname and @searchstringparam is input from user.