Regular Expressions

Bunny Database includes the SQLite regexp extension.

Function	What it does
`regexp(pattern, text)`, `text REGEXP pattern`	Case-sensitive match. Returns 1 for a match and 0 otherwise.
`regexpi(pattern, text)`	Case-insensitive match.

SELECT regexp('^a.c$', 'abc');   -- 1
SELECT 'ABC' REGEXP '^a';        -- 0
SELECT regexpi('^a', 'ABC');     -- 1

SELECT email FROM users WHERE email REGEXP '@example\.com$';

Pattern syntax

The pattern syntax is SQLite’s own regular expression dialect, a POSIX-like subset described in the header comment of the regexp extension source. It supports \d, \w, \s, \b, {n,m} repetition, alternation, and Unicode text. Back-references such as \1 are not supported and raise an error. A NULL argument returns NULL, and an invalid pattern is an error.

Last modified on November 2, 2026

Documentation

Connect

Tools

Reference

Pattern syntax

​Pattern syntax

Pattern syntax