Skip to main content
The regexp extension adds regular expression functions to SQL. It uses the Rust regex crate, which implements a subset of RE2 syntax — the same syntax used by Go and RE2.
The regex engine does not support look-ahead, look-behind, or backreferences. It does support Unicode character classes, anchors, and most common quantifiers.

​
Functions

FunctionArgumentsReturnsDescription
regexp(pattern, string)pattern TEXT, string TEXTINTEGER (0 or 1)Returns 1 if string matches pattern, 0 otherwise
regexp_like(string, pattern)string TEXT, pattern TEXTINTEGER (0 or 1)Same as regexp with arguments reversed
regexp_substr(string, pattern)string TEXT, pattern TEXTTEXT or NULLReturns the first substring of string matching pattern, or NULL if no match
regexp_replace(string, pattern, replacement)string TEXT, pattern TEXT, replacement TEXTTEXTReplaces the first match of pattern in string with replacement
regexp_capture(string, pattern [, group])string TEXT, pattern TEXT, group INTEGERTEXT or NULLReturns the text of capture group group (default 1) from the first match

​
REGEXP operator

Turso supports the REGEXP infix operator in WHERE clauses. It is equivalent to calling regexp(pattern, string): 
SELECT * FROM logs WHERE message REGEXP 'error|warning';
The NOT REGEXP form is also supported: 
SELECT * FROM logs WHERE message NOT REGEXP '^debug';

​
Examples

​
Check if a string matches a pattern

SELECT regexp('\d{3}-\d{4}', '555-1234');
-- 1

SELECT regexp_like('hello@example.com', '^[\w.]+@[\w.]+$');
-- 1

​
Extract the first match

SELECT regexp_substr('Order #12345 placed', '\d+');
-- 12345

​
Replace a pattern

SELECT regexp_replace('hello world', 'world', 'turso');
-- hello turso
Replace with an empty string to delete a pattern: 
SELECT regexp_replace('abc123def', '\d+', '');
-- abcdef

​
Extract a capture group

SELECT regexp_capture('2024-03-15', '(\d{4})-(\d{2})-(\d{2})', 1);
-- 2024

SELECT regexp_capture('2024-03-15', '(\d{4})-(\d{2})-(\d{2})', 2);
-- 03
The default group index is 1: 
SELECT regexp_capture('user:admin', '(\w+):(\w+)');
-- user

​
Filter rows using REGEXP

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

​
NULL handling

All functions return NULL when either pattern or string is not TEXT (including NULL). An invalid regex pattern also returns NULL. 
SELECT regexp(NULL, 'hello');   -- NULL
SELECT regexp('hello', NULL);   -- NULL
SELECT regexp('[invalid', 'x'); -- NULL

Build docs developers (and LLMs) love

Get started for freeTalk to us