MySQL SUBSTRING_INDEX() FunctionThe substring_index() is a String function of MySQL. This function returns a substring from the given string(str) before the counts come of the delimiter. SyntaxParameter:str: main string delim: string to be searched count: number of times to search delim Returns:This function returns the substring of the string before a number of occurrences of delimiter. Example 1Output: Example 2Output: Example 3Output: Example 4Output: Example 5Output:
Next TopicMySQL String
|