var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MySQL Column Split
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
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))
UPDATE smsmsg SET msg1=SUBSTRING(message, 1,POSITION('*' IN message)-1), spmsg=SUBSTRING(message, LENGTH(msg1)+1, 255);