Modify retrieved data from a database without updating

Question

Is there any way that we can modify the retrieved data from a database without changing the original data? Like add_filter() function in PHP.

E.g: we have a cell in the database called Gender, it has two values: 0 (male), and 1 (female). When I show the data I want to replace the 0 with the word "Male" without changing the original 0 in the database! Is it possible?

in what you are taking the data from database, data-set, list and how ?? — Vinay Pratap Singh Bhadauria
– Vinay Pratap Singh Bhadauria, Commented Sep 14, 2015 at 12:25

jarlh · Accepted Answer · 2015-09-14 12:24:41Z

1

Use CASE expression in select list, something like:

select case gender when 0 then 'Male'
                   when 1 then 'Female'
       end
from ...

answered Sep 14, 2015 at 12:24

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Modify retrieved data from a database without updating

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related