SELECT SUBSTRING_INDEX( TrackTitle, ' ', 1) AS w1,
IF(SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 2), ' ', -1) = SUBSTRING_INDEX( TrackTitle, ' ', 1), '', SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 2), ' ', -1)) AS w2,
IF(SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 3), ' ', -1) = SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 2), ' ', -1), '', SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 3), ' ', -1)) AS w3,
IF(SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 4), ' ', -1) = SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 3), ' ', -1), '', SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 4), ' ', -1)) AS w4,
IF(SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 5), ' ', -1) = SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 4), ' ', -1), '', SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 5), ' ', -1)) AS w5,
IF(SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 6), ' ', -1) = SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 5), ' ', -1), '', SUBSTRING_INDEX(SUBSTRING_INDEX( TrackTitle, ' ', 6), ' ', -1)) AS w6
FROM track limit 10
|