November 25, 2019

The SUBSTRING_INDEX helps in extracting a part of the given string from the beginning to the match in the index. Query: SELECT SUBSTRING_INDEX(‘MySQL Database’, ‘a’, 2) AS SUBSTRING_INDEX; Here, the