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

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

How to show in django cms breadcrumbs full path? -

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -