Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

mysql problem

Apr 22, 2003, 3:47 PM
new2mysql
New User (1 post)
Apr 22, 2003, 3:47 PM
Views: 2991
Shortcut
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?
Subject Author Views Date
Post mysql problem new2mysql 2991 Apr 22, 2003, 3:47 PM