Tag archive

#substring

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly

intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Extract Part Of A String With SUBSTRING

Return only part of a text value by position and length.

intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Extract the Nth Field From a Delimited String

Pull out a specific token from a dot- or delimiter-separated string using `SPLIT_PART` (PostgreSQL), `SUBSTRING_INDEX` (MySQL/MariaDB), `PARSENAME` (SQL Server), or nested `SUBSTR`/`INSTR` (SQLite).