MySQL Column Split

the-beast · #1 (**permalink**) 08-13-04, 07:21

I am hoping somebody can help me with a small problem i have.

I am trying to split some data in one column in to two others.

E.g. If i have a column called message in my table (smsmsg) I want to split the data in the message column into two others. The data needs to be split around an *.

Sample data this is the message*other message

In this example the text 'this is a message' will go into one column and the text 'other message' will go into another column.

Any ideas, thanks in advance for any help.

P.S. I am using MySQL 4.0.13

the-beast · #2 (**permalink**) 08-13-04, 11:11

I've managed to do it myself, if anybody is interested this is the code I used (I ended up splitting the message field in to two (msg1 and spmsg))

Code:

UPDATE smsmsg SET msg1=SUBSTRING(message, 1,POSITION('*' IN message)-1), spmsg=SUBSTRING(message, LENGTH(msg1)+1, 255);

Internet Services

Web Development

Digital Marketing

Consumer Tech