Hi I am new to mysql and have a table that has a column that is formated like this
column
thing1/ thing2/thing3
Now i was trying to split thing 1 2 and 3 into 3 columns by using
newcolumn1=LEFT(column,LOCATE('/',column)-1),
which works great for spliting up thing 1 but then i am stumpped how to split up the other 2 can anyone help me?
column
thing1/ thing2/thing3
Now i was trying to split thing 1 2 and 3 into 3 columns by using
newcolumn1=LEFT(column,LOCATE('/',column)-1),
which works great for spliting up thing 1 but then i am stumpped how to split up the other 2 can anyone help me?