Search for text in Database

Question

Is there away to search for text in Database in Sql server

Rakesh Singh · Answer

Hello if u have to search particular column name(stringnumber) or else write query select * from table where column name like '%Rakesh'

tejal bhesaniya · Answer

DECLARE @Search varchar(255) SET @Search='Your Text For Search' SELECT DISTINCT o.name AS Object_Nameo.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id WHERE m.definition Like '%'+@Search+'%' ORDER BY 21

Sudhakar Chaudhary · Answer

You Can Use Full Text Searching. http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-use-full-text-search-in-sql-server-2008/

Chetan Kumar · Answer

Hi U want to search content in column or text data type for tables. u can use like condition if want search particular word or anythin select * from tb1 where ename like '%shil%'