MySQL Forums
Forum List  »  General

Split Values by comma and Check in another Table?
Posted by: rasikow Gnaniyar
Date: January 29, 2009 11:57AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.