LIKE and NOT LIKE in SQL — a practical guide to SQL LIKE with clear examples you can reuse in real projects.
SQL Tutorial Series (31/100). Prefer one article? Read the complete SQL tutorial.
Short description
Leading wildcards (`%term`) often cannot use normal indexes efficiently.
Like
SELECT * FROM users
WHERE email LIKE '%@example.com';