MySQL Forums :: General :: Split Values by comma and Check in another Table?


Advanced Search

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


Subject Written By Posted
Split Values by comma and Check in another Table? rasikow Gnaniyar 01/29/2009 11:57AM
Re: Split Values by comma and Check in another Table? Jay Alverson 01/29/2009 12:17PM
Re: Split Values by comma and Check in another Table? rasikow Gnaniyar 01/29/2009 10:59PM
Re: Split Values by comma and Check in another Table? Jay Alverson 01/30/2009 08:34AM
Re: Split Values by comma and Check in another Table? Peter Brawley 01/29/2009 08:57PM
Re: Split Values by comma and Check in another Table? rasikow Gnaniyar 01/29/2009 11:08PM
Re: Split Values by comma and Check in another Table? Peter Brawley 01/30/2009 02:27AM
Re: Split Values by comma and Check in another Table? Jay Alverson 01/29/2009 10:16PM
Re: Split Values by comma and Check in another Table? rasikow Gnaniyar 01/29/2009 11:05PM
Re: Split Values by comma and Check in another Table? rasikow Gnaniyar 03/27/2009 01:03AM
Re: Split Values by comma and Check in another Table? Jay Alverson 03/27/2009 06:03PM
Re: Split Values by comma and Check in another Table? Jay Alverson 03/28/2009 02:24PM


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.