MariaDB 10.3

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

create table gc_faktoren
(
labornummer int,
matrix varchar(100),
faktorgw int,
faktoraw int
);
insert into gc_faktoren values (1,'AW',2,3);
insert into gc_faktoren values (2,'aw',3,4);
insert into gc_faktoren values (3,'test',5,6);
select Labornummer, Matrix, FaktorGW, FaktorAW from gc_faktoren


Labornummer
Matrix
FaktorGW
FaktorAW


1
AW
2
3

2
aw
3
4

3
test
5
6


SELECT labornummer, matrix, faktoraw, faktorgw,
CASE WHEN matrix = 'AW' THEN faktoraw
ELSE faktorgw END AS factor
FROM gc_faktoren;


labornummer
matrix
faktoraw
faktorgw
factor


1
AW
3
2
3

2
aw
4
3
4

3
test
6
5
5