Splitting letter in a string to separate row in MYSQL -
i have days(working days school) field in school_calendar
table given below
select days school_calendars id=1;
returns mtwhf result
i want output followed
+---------+ days +---------+ | m | | t | | w | | h | | f | +---------+
doing string 1000 characters long:-
select substr(days, anum, 1) aday school_calendars inner join ( select 1 + units.acnt + tens.acnt * 10 + hundreds.acnt * 100 anum (select 0 acnt union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) units. (select 0 acnt union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) tens, (select 0 acnt union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) hundreds ) sub0 on sub0.anum <= length(days) id=1;
for short varchar(7) can simplified to
select substr(days, anum, 1) aday school_calendars inner join ( select 1 anum union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 ) sub0 on sub0.anum <= length(days) id=1;
Comments
Post a Comment