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

Popular posts from this blog

html - Difficulties with background-image property -

visual studio code - What does the isShellCommand property actually do and how should you use it? -

ios - Segue not passing data between ViewControllers -