MySQL - Compare comma-separated field in the same table

Asked Sep 19 '15 at 06:58

Active Sep 19 '15 at 08:22

Viewed 40 times

I have a table named "details" which looks like this:

UID |caste|
001 | 1   |
002 | 1,2 |
003 | 2   |
004 | 1   |

How do I select uids which have the same caste like this:

UID  |sameuidcaste
 001 | 002 
 001 | 004

I have tried this code but it doesn't give what I want:

select a.uid from details as a right join 
 details as b on a.caste = b.caste where b.caste like '%3%'

Any hint will be appreciated! Thank you!

edited Sep 19 '15 at 08:22

HectorJ

asked Sep 19 '15 at 06:58

3

here's a hint. Normalize your data. – Drew Sep 19 '15 at 07:06
thanks your comment but how i normalize this? – PubuduPranith Jayarathna Sep 19 '15 at 07:19
See http://stackoverflow.com/a/11463122/1685538 – HectorJ Sep 19 '15 at 07:36
@ HectorJ thank you very vry very very very much – PubuduPranith Jayarathna Sep 19 '15 at 08:04
@Toby Allen sorry for that, i couldn't find out it. – PubuduPranith Jayarathna Sep 19 '15 at 13:47

0 Answers0