MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT 'Oh My!' WHERE 1 NOT IN (0, 2, NULL)


Oh My!


SELECT 'Oh My!' WHERE 1 NOT IN (0, 2)


Oh My!


Oh My!


create table employee(name varchar(50),ph_no varchar(10),e_id varchar(5),pay_scale varchar(5),year varchar(4));
insert into employee(name,ph_no,pay_scale,year) values('AMIT','123456','PL-10','2019');
insert into employee(name,ph_no,pay_scale,year) values('AMIT','123456','PL-10','2020');
insert into employee(name,ph_no,pay_scale,year) values('AMIT','123456','PL-11','2021');
insert into employee(name,ph_no,pay_scale,year) values('AMIT','123456','PL-11','2022');

select * from employee


name
ph_no
e_id
pay_scale
year


AMIT
123456
  
PL-10
2019

AMIT
123456
  
PL-10
2020

AMIT
123456
  
PL-11
2021

AMIT
123456
  
PL-11
2022


update
  employee
set
  e_id='0132'
where
     name      = 'AMIT'
 and ph_no     = '123456'
 and pay_scale = 'PL-10'
 and e_id      not in (select e_id from 
                        (select distinct e_id
                           from employee
                          where e_id IS NOT NULL
                        )
                        as t
                       );
select * from employee


name
ph_no
e_id
pay_scale
year


AMIT
123456
0132
PL-10
2019

AMIT
123456
0132
PL-10
2020

AMIT
123456
  
PL-11
2021

AMIT
123456
  
PL-11
2022

`name`	`ph_no`	`pay_scale`	`year`
`AMIT`	`123456`	`PL-10`	`2019`
`AMIT`	`123456`	`PL-10`	`2020`
`AMIT`	`123456`	`PL-11`	`2021`
`AMIT`	`123456`	`PL-11`	`2022`

`name`	`ph_no`	`e_id`	`pay_scale`	`year`
`AMIT`	`123456`	`0132`	`PL-10`	`2019`
`AMIT`	`123456`	`0132`	`PL-10`	`2020`
`AMIT`	`123456`		`PL-11`	`2021`
`AMIT`	`123456`		`PL-11`	`2022`