<https://forums.phpfreaks.com/topic/309892-how-to-fetch-the-filename-on-split/#comment-1573626>
<http://schema.org/text>
"Get the query to do the work.\n \n\n\nmysql&gt; SELECT attached_files\n    -&gt;      , TRIM(SUBSTRING_INDEX(attached_files, ':', -1)) as filename\n    -&gt; FROM mark107;\n+---------------------------------+--------------+\n| attached_files                  | filename     |\n+---------------------------------+--------------+\n| attid: 0 filename: email1.png   | email1.png   |\n| attid: 1 filename: email2.png   | email2.png   |\n| attid: 2 filename: email3.png   | email3.png   |\n| attid: 3 filename: my_inbox.png | my_inbox.png |\n+---------------------------------+--------------+\n"
<https://forums.phpfreaks.com/topic/309892-how-to-fetch-the-filename-on-split/?tab=comments>