SQLite 3.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE personal_websessions(id_no INTEGER PRIMARY KEY, website_link TEXT);
INSERT INTO personal_websessions VALUES(1, 'google.com msn.com gmail.com'), (2, 'stackoverflow.com  reddit.com'), (3, 'msn.com ');
with cte(id_no, website_link, rest, lev) as (
      select pw.id_no, NULL as website_link, trim(pw.website_link) || ' ' as rest, 1 as lev
      from personal_websessions pw
      union all
      select cte.id_no,
             trim(substr(cte.rest, 1, instr(cte.rest, ' '))),
             substr(cte.rest, instr(cte.rest, ' ') + 1),
             lev + 1
      from cte
      where rest <> '' and lev < 10
     )
select id_no, website_link
from cte
where website_link <> ''
order by id_no


id_no
website_link


1
google.com

1
msn.com

1
gmail.com

2
stackoverflow.com

2
reddit.com

3
msn.com

id_no	website_link
1	google.com
1	msn.com
1	gmail.com
2	stackoverflow.com
2	reddit.com
3	msn.com