MySQL Forums
Forum List  »  MySQL Query Browser

split string into columns
Posted by: sarath chandra
Date: May 16, 2013 02:12AM

I have the following data into table "admin_interval"

admin_interval table
--------------------
row1: "00:00:00 - 06:00:00, 22:00:00 - 23:59:59"
row2: "05:00:00 - 06:00:00"

and i want to split string into separate columns like from1, to1 from2, to2.

from1 to1 from2 to2
row1 00:00:00 06:00:00 22:00:00 23:59:59
row2 05:00:00 06:00:00
-----------------------------------------------

Could you please let me know how to do this in best way?

Options: ReplyQuote


Subject
Written By
Posted
split string into columns
May 16, 2013 02:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.