if語句可以進行條件判斷, 實際上if函數(shù)也可以

if語句

IF search_condition THEN
    statement_list
ELSE
    statement_list
END IF;

if 函數(shù)

IF(expr1,expr2,expr3)

含義也很簡單: 如果expr1為真, 則執(zhí)行expr2, 否則執(zhí)行expr3

根據(jù)存款, 判斷是土豪還是low逼

drop table if exists test;

create table `test` (
  `id` int(11) not null auto_increment,
  `name` varchar(10) not null,
  `account` int(11) not null,
  `age` tinyint(1) not null,
  `sex` char(1) not null default '男',
  primary key (`id`)
) engine=innodb auto_increment=1 default charset=utf8;

insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (1, '張三', 3000, 18, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (2, '李四', 4000, 28, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (3, '王五', 5000, 38, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (4, '趙六', 6000, 48, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (5, '孫七', 2000, 19, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (6, '周八', 1000, 29, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (7, '吳老九', 9000, 39, '男');
insert into `test`(`id`, `name`, `account`, `age`, `sex`) 
    values (8, '馮老十', 8000, 49, '男');

select id,
    name,
    account,
    age,
    sex,
    if(account >= 5000,'土豪','low逼') as type 
from test;`

結(jié)果如下:

image.png