How do I REPLACE values in column after querying
You can use CASE for what you're using the replace for. Also, I've modified the WHERE to be more streamlined;

SELECT
CASE 
    WHEN column = '1' THEN 'ABC'
    WHEN column = '2' THEN 'DEF'
    WHEN column = '3' THEN 'GHI'
    WHEN column = '4' THEN 'JKL'
END AS column
FROM table
WHERE column IN ('1','2','3','4')


As a note, if column is an int then you don't need to wrap the values in ''

SELECT
CASE 
    WHEN column = 1 THEN 'ABC'
    WHEN column = 2 THEN 'DEF'
    WHEN column = 3 THEN 'GHI'
    WHEN column = 4 THEN 'JKL'
END AS column
FROM table
WHERE column IN (1,2,3,4)


This won't modify the table at all, it will just change the way that the data is displayed.