STRPOS
Returns the position of the first occurrence of a substring. Alias for LOCATE.
Analyze Syntax
func.strpos(<str>, <substr>)
Analyze Examples
func.strpos('hello world', 'world')
┌───┐
│ 7 │
└───┘
SQL Syntax
STRPOS(<str>, <substr>)
SQL Examples
SELECT STRPOS('hello world', 'world');
┌───┐
│ 7 │
└───┘