instr()

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

Arguments & returns

Scalar

Overload link	`string`	`search_string`	Returns
#01	`VARCHAR`	`VARCHAR`	`BIGINT`

SELECT instr('test test', 'es');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.