I have column in my table name "item_code". It contains code like: 011, 002, etc. I have put them to recognize catogories for e.g. colors.
code: 001, 002, 003 color: red, green, blue
I don't want the code but want to display color as they are appearing more then one time in my table and I can't get them in code condition. Can you tell me the query which can change the code to some informative text.