INSTR

Use INSTR to return the position of the first occurrence of a substring within a string. The first parameter is the string to search. The second parameter is the string to find within the search string.

INSTR(string_to_search, string_to_find)

SELECT INSTR('baseball team', 'team')