LIKE searches for patterns in text columns using wildcards. Essential for flexible text searching.

Wildcards

% - Matches any sequence of characters

_ - Matches exactly one character

Starts With

SELECT * FROM products WHERE name LIKE 'Apple%';

Ends With

SELECT * FROM customers WHERE email LIKE '%@gmail.com';

Contains

SELECT * FROM products WHERE description LIKE '%wireless%';

Single Character Wildcard

SELECT * FROM products WHERE code LIKE 'A_123';

NOT LIKE

SELECT * FROM customers WHERE email NOT LIKE '%@test.com';

Case Insensitive (MySQL)

SELECT * FROM products WHERE LOWER(name) LIKE '%phone%';

Generate Pattern Queries

Describe your search pattern and AI2sql creates the LIKE query.