STRPOS
Returns the position (in bytes) of the substring found in the string, starting from 1. The returned value is for the first matching value, and not for any subsequent valid matches. In case the substring does not exist, functions will return 0.
Syntax
STRPOS(<string>, <substring>)
Parameter | Description |
---|---|
<string> | The string that will be searched. |
<substring> | The substring to search for. |
Example
SELECT
STRPOS('hello world','hello') AS res;
Returns: 1
SELECT
STRPOS('hello world','world') AS res;
Returns: 7
SELECT
STRPOS('hello world','work') AS res;
Returns: 0