MySQL - Split a string where substring is found

select 
   SUBSTRING_INDEX('part 1, part 2', ',', 1) as part_1
   , SUBSTRING_INDEX('part 1, part 2', ',', -1) as part_2
;

MacOS - Folder file count in terminal

find . -not -type d | wc -l