Substituting SQL queried values by other values

Some times you need the queried values to be substituded by some other value just during the query time and not to actually change anything withing the database.

SELECT 
    *,
    CASE `emailnotificationsent`
        WHEN 1 THEN 'true'
        ELSE 0
    END
FROM
    `brasresponse`
ORDER BY `sequence` DESC

It should be self explanatory.

Comments

Popular posts from this blog

Testing SOAP services using pingdom