WR6X0HaV

1drop table if exists foo;
2create table foo
3(
4id int unsigned not null auto_increment primary key,
5bar varchar(32) not null
6)engine=innodb;
7
8insert into foo (bar) values ('aaa'),('bbb'),('aaa'),('ccc'),('ddd'),('bbb'),('eee');
9
10select 
11 f.*, 
12 if(f.bar = 'aaa', 1,0) as aaa_flag,
13 if(f.bar = 'bbb', 1,0) as bbb_flag, 
14 if(f.bar = 'ccc', 1,0) as cc_flag 
15from 
16 foo f;