How to split one column value into multiple column in phpmyadmin?

Asked Jan 13 '17 at 04:58

Active Jan 16 '17 at 09:26

Viewed 210 times

SELECT `emp_hist` FROM  employee

ANSWER:-

Primary Teacher~2005-2007~RM3000~Study~Primary School Mandarin Teacher~SJKC Yoke Nam~~~~~~~~~~~~~~~~~~~~~~~~

I need to split this value using '~' this symbol in phpmyadmin Can any one help me?

I tried already split_str it doesn't work..

edited Jan 16 '17 at 09:26

denny

asked Jan 13 '17 at 04:58

Asm1990

Split to separate rows? – shmosel Jan 13 '17 at 05:00
Show us your code – Jeroen Heier Jan 13 '17 at 05:36
you can use php `explode()` function to split the values by `~`. or you want to split in `mysql` ? – prakash tank Jan 13 '17 at 05:56
Check if the answers here might help: http://stackoverflow.com/questions/14950466/how-to-split-the-name-string-in-mysql – moni_dragu Jan 13 '17 at 10:54

0 Answers0