SQL · String functions

strpos()

The one-based position of a substring, or 0. SQLite uses instr().

sqlRunnable example sql course

Syntax

strpos(text, substring)

Example

Open in the lab

SELECT instr('EduByte', 'Byte') AS position;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.