Files
Ophir LOJKINE 0d5373509a new function: sqlpage.regex_match (#1271)
* new function: sqlpage.regex_match

* fix mysql tests

* Update CHANGELOG.md
2026-04-08 21:39:32 +02:00

9 lines
239 B
SQL

set route = sqlpage.regex_match(
'/categories/(?<category>[A-Za-z0-9_]+)/post/(?<id>[0-9]+)',
'/categories/sql/post/42'
);
select
'{"0":"/categories/sql/post/42","category":"sql","id":"42"}' as expected,
$route as actual;