When using LIKE search, the index works up to the wildcard. e.g., LIKE 'test%' → OK, LIKE '%test%' or LIKE '%test' → NG. But since partial matches with wildcards on both sides are common, it seems unlikely that indexes will be used much in LIKE searches.