position Function in MYSQL

In MySQL, the POSITION function is not directly available. Instead, the LOCATE function is used to find the position of a substring within a string. The LOCATE function returns the position of the first occurrence of a substring within a string. If the substring is not found, it returns 0.

Here's the syntax of the LOCATE function in MySQL:

LOCATE(substring, string)

- substring: The substring to search for within the string.

- string: The string in which to search for the substring.

Example:

SELECT LOCATE('world', 'hello world') AS position;

This will return 7, indicating that the substring 'world' starts at the 7th position within the string 'hello world'.