LIKE

Keyword LIKE

Match expression with pattern.

Syntax:

    expression LIKE pattern

The pattern syntax uses these special characters:

• % - any amount of any character
• _ - Exactly one character of any type

In AlaSQL the match is case-insensitive meaning we are aligning with MySQL, MSSQL and SQLite.

Database	LIKE Default	ILIKE Support	Notes
PostgreSQL	Case-SENSITIVE	✅ Case-insensitive	ILIKE is PostgreSQL extension
Oracle	Case-SENSITIVE	❌	Use UPPER()/LOWER() instead
MySQL/MariaDB	Case-INSENSITIVE*	❌	*Depends on collation (default: ci)
MSSQL	Case-INSENSITIVE*	❌	*Depends on collation (default: ci)
SQLite	Case-INSENSITIVE**	❌	**ASCII only; case-sensitive for non-ASCII
AlaSQL	Case-INSENSITIVE	⚠️ Same as LIKE	All variants are case-insensitive

Please note that Postgres and Oracle behaves differently and the SQL might need to be adapted.

See also: MATCH