SUBSTRING_INDEX() FUNCTION in MySQL
SUBSTRING_INDEX() FUNCTION The MySQL SUBSTRING_INDEX function is used to get the substring of string before several occurrences of delimiter. The various versions of MySQL support the SUBSTRING_INDEX function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: SUBSTRING_INDEX( string, delimiter, number ) Parameters: string: It … Read more