Re: Inserting boolean types as an alias?

On 12/2/2013 3:46 PM, Nick wrote:
> Hello I am new to this site and also a student. I am working on an assignment
> and was wondering if there is a way to make an alias for a boolean? For
> example when I am making a table called club_games and it must contain the
> memberID, gameID, count, and status as column fields. When I enter the data
> for status I want it to say either "unavailable" for false and "available"
> for true. but I don't know how to do that.

you could use an enum, or you could use a case statement on your query,
like,

SELECT memberID, gameID, hardwareID, count, case when status then 'available' else 'unavailable' end FROM club_Games




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast