SQL · String functions

instr() with start

Finds a substring and returns a one-based position, or 0.

sqlRunnable example sql course

Syntax

instr(text, substring)

Example

Open in the lab

SELECT instr('banana', 'na') AS first_position;

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