MariaDB Case statement

I have the following SQL-Code in a Mariadb-Database: (1)

select Labornummer, Matrix, FaktorGW, FaktorAW from gc_Faktoren 

I need the following result:

If Matrix='AW' => I need the field "FaktorAW"

else => I need the field "FaktorGW"

is it possible to formulate Statement (1) with a "case statement"?

2 Answers

Of course, this is possible. Basically you can do this:

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

You have to take care if this is really exactly what you want, e.g. this will not check lower/upper case. See the working example: db<>fiddle

Try

select Labornummer, Matrix, FaktorGW, FaktorAW, CASE WHEN Matrix = 'AW' THEN FaktorAW ELSE FaktorGW END as New_Field from gc_Faktor