How do I REPLACE values in column after querying

2 votes

3 answers

100706 views

                          I have a column with numeric values

I am querying

    SELECT column 
    FROM table 
    WHERE column='1' OR
    column='2' OR 
    column='3' OR
    column='4'

THEN

    REPLACE (column, "1", "ABC");
    REPLACE (column, "2", "DEF");
    REPLACE (column, "3", "GHI");
    REPLACE (column, "4", "JKL")

I am not sure if I may be using the semicolons wrong.

Please help!
                        

Asked by John (51 rep)

Jul 6, 2016, 01:50 AM
Last activity: Jul 6, 2016, 08:32 AM

How do I REPLACE values in column after querying

Related Questions