ravinder.pathania

 Profile Answers by ravinder.pathania 

• Oct 6th, 2008

 

The wildcard char % can be placed in one of three ways:

%searchwordhere%
searchwordhere%
%searchwordhere

The searchwordhere% is the fastest because it can use an index if one is specified on that column. The other two %searchwordhere%, and %searchwordhere would never use the index even if one is specified and thus result in slow table scans.