splitting apart a mysql column with mutliple values. Not sure how to display

If you want something "dirty" that may do the job (temporarily), try something like this. It isn't pretty and only works for a set number of substrings values.

SELECT
  tp.id,
  tp.selected_y,
  tp.selected_m,
  SUBSTRING_INDEX(tp.all, 'add to bob', 2) AS value
  FROM tp
UNION
SELECT
  tp.id,
  tp.selected_y,
  tp.selected_m,
  SUBSTRING_INDEX(SUBSTRING_INDEX(tp.all, 'add to bob', 3), 'add to bob', -1) AS value
  FROM tp
UNION
SELECT
  tp.id,
  tp.selected_y,
  tp.selected_m,
  SUBSTRING_INDEX(SUBSTRING_INDEX(tp.all, 'add to bob', 4), 'add to bob', -1) AS value
  FROM tp

Code (markup):

 

thank you.