I have a situatioln in sql where i want to select from but if the column value is let's say apple i want to select as fruit.
from db table = table1
column name = fruits
column name = veggies
when i select i dont' wnagt to save as apple or bananas but instead the query should retrun fruit
select fruits as fruit , veggies as veg
where fruits = 'apple' or fruits = 'bananas'
I hope I make sense. maybe I need a case statement.