MySQL to select ENUM ('M', 'F') as either 'Male' or 'Female'

Question

My field is ENUM for gender and saves “M” or “F”, but is there a way to select the field as “Male” or “Female” based on the value?

Answer 1

SELECT IF(gender='M','Male', 'Female') AS Gender 

Answer 2

You can do things for him:

 SELECT CASE enum_field WHEN 'M' THEN 'Male' WHEN 'F' THEN 'Female' END 

Answer 3

Yes, you can use the following query to do this.

 SELECT (CASE WHEN field = 'M' THEN 'MALE' WHEN field = 'F' THEN 'FEMALE' END) AS sex FROM table; 

Answer 4

Use the CASE statement, for example:

 SELECT CASE FieldName WHEN 'M' THEN 'Male' ELSE 'Female' END FROM TableName 

Answer 5

Other technique

 select replace(replace(column,'M','Male'),'F','Female') from table