Skip to contents

Returns location of first occurrence of search_string in string, counting from 1. Returns 0 if no match found.

Usage

instr(string, search_string)

Arguments

string, search_string

VARCHAR

Value

BIGINT

SQL examples

instr('test test', 'es')
position('b' IN 'abc')