https://www.w3schools.com/mySQl/func_mysql_substring_index.asp
MySQL SUBSTRING_INDEX() Function
Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML...
substring indexmysqlfunction