**Performance:**

- LIKE with leading wildcard (%) cannot use indexes

- LIKE 'prefix%' can use indexes efficiently

- REGEX generally slower than LIKE

- Consider full-text search for complex text queries

LIKE 'prefix%' can use indexes efficiently

LIKE '%suffix' requires full table scan

REGEX generally slower than LIKE

Index columns used in pattern matching

Consider materialized views for complex patterns

Use full-text indexes for text-heavy searches

Forgetting % wildcard matches zero characters

Using LIKE when exact match (=) would work

Not escaping special characters in patterns

Assuming LIKE is case-insensitive across databases

Using REGEX for simple patterns (overkill)

Not testing patterns with edge cases