Wednesday, May 2, 2012

SQL hashtags regex to table

I have this table:



p_id        name      skills
1 Sam #IT #communication #administration
2 Alex #French #Trainer


i want an sql query to output this



  ID     p_fid   skill
1 1 IT
2 1 communication
3 1 administration
4 2 French
5 2 Trainer


im using MS Access, but i would use a different RDBMS if Access can't do this and another RDMS can



Thanks a lot





No comments:

Post a Comment