Split Values by comma and Check in another Table?
Hi all,
I am Zubair, new to this group. I have one doubt in mysql query. hope anybody will give the right solution.
i want to split some values from one field and want to check in other table. hope you are not clear. :)
For example,
TABLE1
======
id primarySkill
1 2318, 5236, 8541
2 5236,8762
3 8541, 2318, 5236, 8762
TABLE2
======
id value
2318 java
5236 php
8541 .net
8762 Photoshop
i want TABLE1 ouput like this:
=====================
id primarySkill
1 java,php, .net
2 php, Photoshop
3 .net, java,php, Photoshop
how to write query for this? your swift action shall be highly appreciated
Thanks in advance
- Gnaniyar Zubair