Example
Return a substring of a string before a specified number of delimiter occurs:
SELECT SUBSTRING_INDEX("www.iampsp.com", ".", 1);
Definition and Usage
The SUBSTRING_INDEX() function returns a substring of a string before a specified number of delimiter occurs. Continue reading MySQL SUBSTRING_INDEX Function