explode a cell

homer.favenir · #1 (**permalink**) 11-11-08, 21:26

hi,
how to explode a field content?

thanks

r937 · #2 (**permalink**) 11-12-08, 02:14

INSERT INTO table (tablecell) VALUES ('dynamite');

UPDATE table SET tablecell.fuse = 'on fire'

stand well back

homer.favenir · #3 (**permalink**) 11-12-08, 02:21

Quote:

Originally Posted by r937

INSERT INTO table (tablecell) VALUES ('dynamite');

UPDATE table SET tablecell.fuse = 'on fire'

stand well back

how to split a field

field
1-2
3-5
6-7
7-10

in php its explode
explode('-', $field)

but i dont know in mysql

r937 · #4 (**permalink**) 11-12-08, 03:08

use SUBSTRING_INDEX function

homer.favenir · #5 (**permalink**) 11-12-08, 22:44

thanks! good tutor....