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 
