newtomysql
04-23-2003, 04:59 AM
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?:confused:
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?:confused: