Use case when statement in mysql

The following is an example of how to use the case when statement in mysql for your reference. If you are interested in the use of case when statements in mysql, take a look.

1.

 
 

  
  
select name,  
  
  
 case   
  
  
        when birthday<'1981' then 'old'  
  
  
        when birthday>'1988' then 'yong'  
  
  
        else 'ok' END YORN  
  
  
from lee; 
 
 

2.

 
 

  
  
select NAME,  
  
  
 case name  
  
  
     when 'sam' then 'yong'  
  
  
        when 'lee' then 'handsome'  
  
  
        else 'good' end  
  
  
from lee; 
 
 

Of course, the case when statement can be combined.

3.

 
 

  
  
select name,birthday,  
  
  
 case   
  
  
     when birthday>'1983' then 'yong'  
  
  
        when name='lee' then 'handsome'  
  
  
        else 'just so so ' end  
  
  
from lee;  
  
  
 
 
 

The above is an example of how to use the case when statement in mysql.

How to Set auto-increment fields in MySQL

Default length of common MySql Fields

Range of MySQL numeric data types

MySQL index type

How to add or delete a primary key in mysql