An operator for searching strings by partial or prefix match, among others.
An operator that uses wildcards (% and _) to search by substring, prefix, or suffix match. A prefix match (e.g., 'abc%') can use an index, but a substring match with a leading wildcard ('%abc%') can't use an index and tends to force a full scan.
© 2026 ITBGM