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.