FIND YOUR NEXT FEW LINES
The snippet library.
Small, practical examples. Search by task or narrow things down below.
5 snippets foundClear filters
Extract part of a string
Use one-based positions with substr.
substr✓ Tested
Generate numbers with a recursive CTE
Build a bounded sequence using SQL recursion.
recursive CTE✓ Tested
Join values with a delimiter
Concatenate rows in a specified order.
group_concat✓ Tested
Number a sorted result
Assign a row number without changing stored data.
row_number✓ Tested
Search a small FTS5 table
Use SQLite’s full-text index to match a term.
FTS5✓ Tested