MariaDB Case statement-CodePudding

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"?

CodePudding user response：

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

CodePudding user response：

Try

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