Searches Sitecore field values for a search term, via SQL.

Sitecore Term Search with SQL.sql

use XXX_Sitecore_Master

declare @searchTerm varchar(100)
declare @onlySearchLayouts bit
/*
	If using parameters, they must be escaped:
%2b = space
%252f = /

	If using DataSource, they don't.
*/
set @searchTerm = 'studentbio'

set @onlySearchLayouts = 0

select top 10 *
from SharedFields f
	left join Items i on f.ItemId = i.ID
where Value like '%' + @searchTerm + '%'

If @onlySearchLayouts <> 1
	BEGIN
select top 10 *
from ArchivedFields f
	left join Items i on f.ItemId = i.ID
where Value like '%' + @searchTerm + '%'

select top 10 *
from UnversionedFields f
	left join Items i on f.ItemId = i.ID
where Value like '%' + @searchTerm + '%'

select top 10 *
from VersionedFields f
	left join Items i on f.ItemId = i.ID
where Value like '%' + @searchTerm + '%'
	END

If setting additional parameters on layout items you need to escape slashes and spaces.

set @searchterm = 'Sidebar%2bTextbox%252fMBA%252fCorporate%2bFinance%252f'

If using LINQPad, consider the gist at https://gist.github.com/JamesSkemp/94159859a148b2dbf3d6 instead.