MySQL Function Reference

INSTR

Returns the position of the first occurrence of a substring in a string

MySQL 8.1

INSTR(str, substr)

str

Source string

substr

Search substring

Examples

MySQL 8.1

SELECT INSTR('sql-academy', 'academy');