• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

LOCATE()

Return the position of the first occurrence of a substring. 

Prototype

int LOCATE(string substr, string str[, int position])

Parameters

• substr - The substring to find the position of in str.
• str - The string or expression to evaluate to a string to search for substr.
• position - Optional position to start searching from.

Return

Returns the position of the first occurrence of substring substr in string str, where 1 is the first character.  If position is provided, the first occurrence of substring substr in string str, starting at position will be returned.  Returns 0 if substr is not in str.  Returns NULL if any argument is NULL.

Example

SELECT OID, LOCATE(Username, Email) AS UsernamePos FROM User

Related

IN_STR()

• < LENGTH()
• LOWER() >