LIKE

Matches a string against a pattern using % (any characters) and _ (single character) wildcards.

Analyze Syntax

func.like(<str> LIKE <pattern>)

Analyze Examples

get_column(table, 'name').like('%alice%')

┌───────────┐
 (boolean)  
└───────────┘

SQL Syntax

LIKE(<str> LIKE <pattern>)

SQL Examples

SELECT name FROM users WHERE name LIKE '%alice%';

┌─────────────┐
 alice_smith  
└─────────────┘