Gossamer Forum
Home : General : Databases and SQL :

mysql problem

Quote Reply
mysql problem
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?