SELECT products1.id, products1.pro_title,
SUBSTRING_INDEX(pro_title,' ',1) AS part1, 
SUBSTRING_INDEX(SUBSTRING_INDEX(pro_title,' ',2),' ',-1) AS part2,
SUBSTRING_INDEX(SUBSTRING_INDEX(pro_title,' ',3),' ',-2) AS part3,
SUBSTRING_INDEX(SUBSTRING_INDEX(pro_title,' ',4),' ',-3) AS part4,
SUBSTRING_INDEX(SUBSTRING_INDEX(pro_title,' ',-4),' ',3) AS part5,
SUBSTRING_INDEX(SUBSTRING_INDEX(pro_title,' ',-3),' ',2) AS part6,
SUBSTRING_INDEX(SUBSTRING_INDEX(pro_title,' ',-2),' ',1) AS part7,
SUBSTRING_INDEX(pro_title,' ',-1) AS part8
FROM products1;