Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


    • CommentAuthorjustnajm
    • CommentTimeNov 23rd 2006
     
    Hi,

    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.

    Thanks in advance,
    Najm.