Is there a way to explode a cell value within a mysql statement -

i have column in table store tag ids 1|5|10

i want explode column using mysql query

what might want not store tag ids this. make separate table them , problem dissapear naturally.

that's called normalisation.